city

Need to calculate number of boxes. Need to add "TM" in another row and highlight in yellow and another blank row. Total the qty. 5 In Big Box 3 or 4 in Medium Box 1 or 2 in small box TM names vary from 1 to 15 Here is the example Any formula to do this <tbody> TM Address City State Zip...

Hello Folks , I have a workbook with 2 sheets (Sheet1 and Sheet2) Sheet1 has 3 columns (Column A- Name , Column B - City , Column C - PSF ID's) , Name and City is mapped and PSF ID's column is blank Sheet2 has 3 columns (City Column A, Name Column B, PSF ID's Column C) all the 3 columns are...

Dear All, I am working on logical calculation where logic will involve 5 cells, can anybody help me build logic using below statement / Table 1> if City is Delhi , Indore -If type of work is "Polish" Purpose is "Preventive" Location of the work is "Field" Payment should be on Turn around time...

Hi guys I have been searching and searching and I can't get it working. I am using google forms and I would like to receive by email the answers as data. I.E. Column A will be Name, column B, age and column C city. So I would like to receive an email for everytime someone's answer and be...

Thanks in advance. This is a copy of part of worksheet 1 which is a horse racing rating method: <tbody> Chelmsford City 16.45 (in cell A1) Horse Points Satchville Flyer 233 Irish Times 177 Red Cossack (CAN) 174 Kellington Kitty (USA) 143 Pass The Cristal (IRE) 138 </tbody> On...

i have following formula to find the average of top 2 sales in each city AvgTopSales:=AVERAGEX(topn(2,summarize(ALL(Table1),Table1[Parlour],"TotSales",[Tot])),[TotSales]) currently my pivot table look like as below. in city1 i am supposed to get 1646.5 (avg of 1978 &1315) but above formula...

<tbody> A B C D 1 United Red 2 United 3 City Blue 4 United 5 City 6 Spurs White 7 Spurs </tbody> Hiya How do I get Col B to cells to populate with "Red" if the cell in Col A is 'United'? Likewise City in B5 should populate as "Blue"; and...

I suspect I need to use a different function but I am trying to lookup data and in one tab the city name is in one column, but the tab with the data the city names are spread out over manmy columns. <colgroup><col><col span="3"></colgroup><tbody> Location Revenue Expenses Boston 150000...

Hello, I am trying to format some addresses. They are currently "Street Address, CITY" and I am trying to remove the City along with the Comma. Example: 9062 Old Annapolis Rd, COLUMBIA Want: 9062 Old Annapolis Rd I have tried flash fill and while that mostly worked it went wonky on...

Hi, I will use Excel maps for my data, but 1 city (Izmir) is not available in Turkey map. i write the name of the city right, all other cities are now colored except Izmir. How can i find the defined name in maps-turkey for Izmir. BR, Metin

hello, I have some data in 4 cells and i need their unique value in a single cell in below format. <tbody> CITY ZIP AREA CODE UNIC NAME MUMBAI 853024 2019 MBHA MU_19_BH_24 </tbody> Thanks

I have city and state in a column but need to add a comma after city and before state.

Hi I have blank cells in the sheet below (please see the link). To fill these blank cells, I want to copy the content of the cells above. In the original sheet, I just highlighted the first few cells with yellow for you. Thank you very much Example <tbody> contract key name location date...

Hello All, Can someone please help me with a formula to find the largest time value in the scenario below? <colgroup><col><col></colgroup><tbody> 09:06:15 To City 09:22:11 To City 09:23:04 To City 09:27:51 To City 09:28:53 Dead 10:27:05 Dead 10:28:17 Dead 16:25:08 Dead...

Trying to perform an index and match based on partner name. If name is found then look to see if they have services in Agriculture (and then Airway, Smart Building, etc.) from table1[[V1]:[V4]]. If found return partner name. <tbody> Company Agriculture Airway Smart Building Smart City...

Hi, Is there an elegant formula way to count unique values or text based on multiple conditions. Countifs formula works but it does not count unique values, it counts all records based on # of records in the data set. Based on research I've seen some examples using arrays and sumproduct - it...

I am combining data in several columns into one single column using this formula: =OFFSET($F$2:$F$509,MOD(ROW()-ROW(ColumnData1),ROWS($F$2:$F$509)),TRUNC((ROW()-ROW(ColumnData1))/ROWS($F$2:$F$509),0),1,1) Then I'm using this formula to ignore blank and zero cells, round the number and only look...

Hello Everyone, I am looking for a dax function measure for powerpivot report which would return the value based on a lookup value from different table. For Example,I have 2 tables as follows <tbody> City Name State_Code Mumbai MH Pune MH Chennai TM Noida UP </tbody> <tbody>...

Hi all, I've got a large data set (roughly 1,500 cells) that I need to split out. They are currently formatted like this: <colgroup><col></colgroup><tbody> CHICOPEE, MA TO Rocky Mount, NC MCDONOUGH, GA TO ROCKY MOUNT, NC ATLANTA, GA TO ORLANDO, FL I'm trying to separate this into four...

Hi, I am looking to change the pivot field rows based on a selection from a drop down. For example, I have a pivot with Zone (North, South, East, West), City and Sales. The summary table picks up data from this pivot. The user can select whether he wants to view the summary by Zone of City...