depot

Help please...I want to count the number of unique values in Column B (delivery postcode) where column I is a specific value (delivery depot) eg how many postcodes did a specific depot deliver to. I've tried multiple variations of countif, frequency, match etc but can't seem to get it right :(...

I want to find out how many of my company's customers are in the Fortune 500. I have both lists, but am not sure how to compare them. Also, how would I handle common words like "the" or "of?" I guess I could do an exact match, but then I might miss close matches, for example, we might have a...

Hi, I have a spreadsheet where customer codes are entered. All customer codes start with C and then the letter of the depot followed by 6 digits, a dash, and then the depot letter again. For example, CM123456-M. Is there a way to highlight the cell if the end letter has been input...

Hello All, I have data that is similar to the one below: <colgroup><col><col><col></colgroup><tbody> Name Place GEE 50 Depot 50 50 ABC 53 50 GEE 50 SGEE 50 GEESTN 50 DRG 51 Depot 51 ABC 51 FED 51 SGTE 51 GEST 51 DRG 53 Depot 53 ABC 53...

Hi, I am working on a chart that at the moment has three sections on the Y axis I would like to customize it so that the labels read Depot, Working, Collecting, Travel, Other Which would be determine by: Depot = 0.5 Working = 1 Collecting = 1.5 Travel = 2 Other = 0 Can anyone help please?

Hi All, I have database where one Colum is for Stores Like Stores Home Depot Home Depot First Home Depot Second Ralphs Food 4 Less . . . . . . . By Macro Im trying to extract data for store “Home Depot” only. In Criteria range I have: Stores Home Depot Sub Filter_Stores()...