Another option is to add a "helper" column to your table, using formula: =G24&H24 (and copy this formula down the table) And then use thi...
I think I know what happened. The file was too big and was rejected. I deleted a lot of rows on your "Retailer Codes" tab so the size could be reduc...
I've uploaded a file where I put the data in the first sheet in a table. I don't know if you want all the data in the same table, but you should get ...
First, I would put the data on the first sheet in a table (like it is in your last sheet). In fact, I would put everything I possibly could in tables...
Yes, a workbook would be helpful, but you can probably just use VLOOKUP or Index/Match to get what you want.
I don't know what you are asking. What column (please supply a column header, like "Column Q") are you looking to get the minimum number, excluding 0...
BC27? That cell is a header - "Acne/ Problematic Skin Line" Also, cells BC22:BC25 should be set as "Numbers". Right now if you type a number in, ...
That's a good one Sunny. I would not have thought of that, but since you offered that up, it got me thinking about negative numbers, so this formula ...