Hi guys,
i need help in something like this. let's say i have the following data:
Apple - from Column A1 ~ A25
Orange - from Column A26~A34
Pineapple - from Column A35~A47
in Column B, i would like to have a 'function' or a counter that counts if Excel finds:
1. Apple within A1~A47, it counts and adds '1' through '25' to B1 through B25;
2. Orange within A1~A47, it adds '1' through '9' to B26 through B34,
3. Pineapple within A1~A47, then add '1' through '13' to B35 through B47.
thank you very much in your help in advance.
Bookmarks