two critera

Hello, I have a file A with product ID's and the date they were sold. I have another file B with the historical cost of these products and the dates the cost was changed/updated. I need to find the pricing for the products ID's in file A on the date they were sold (also in File A). Is there a...

Hi all, I want to know how much cell have a blue Font color within the cells that have a green background (and so on, 5 background colors and 5 Font colors). Exemple: I have 20 cells that have a green background, from those cells how much have a blue Font? Here are my formulas: Background...

<tbody> KIT 1 KIT 2 KIT 3 KIT 4 APPLES ORANGES APPLES LIMES BANANAS WATERMELON LEMONS ORANGES ORANGES ORANGES WATERMELON </tbody> Lets say I have these kits. I would like to write a macro that allows me to search through all kits and return the kit names that have certain (multiple)...

Really struggle with Excel, so this might be a quick and easy one for someone out there?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I want to conditional format a worksheet, which is to check for two criteria’s in two columns to capture...