CarelessBeaver
New Member
- Joined
- Sep 14, 2017
- Messages
- 2
Hello,
This is my first post on this forum. I have been tasked with compiling data from the same column in many sheets (290).
-The sheets are all in the same workbook and have an incremental name (SO17000-SO17290).
-The column contains data that looks like this: 6129/110
I need to compile how many iterations there are of each individual data entry in the range $E$21:$E$61
Furthermore, I'd need to be able to tell if the value that is in the field to the right ($F$21:$F$61) is different than N/A or TBA.
This all looks too complicated and I feel somewhat desperate so any help will be welcome.
Thank you
This is my first post on this forum. I have been tasked with compiling data from the same column in many sheets (290).
-The sheets are all in the same workbook and have an incremental name (SO17000-SO17290).
-The column contains data that looks like this: 6129/110
I need to compile how many iterations there are of each individual data entry in the range $E$21:$E$61
Furthermore, I'd need to be able to tell if the value that is in the field to the right ($F$21:$F$61) is different than N/A or TBA.
This all looks too complicated and I feel somewhat desperate so any help will be welcome.
Thank you