I have 26 columns (A to Z) by 70 rows of text data. I want to count how many times a specific term ("text1") occurs in column J but only count it once if the data in columns D, E and G are identical values. Then return the numerical value in a cell on a different sheet in the workbook.
I hope this meets your needs. All you have to do is use Excel's Advanced Filter to get what you want. Macro or no macro. I highlighted the relevant data with a yellow fill.
Book1.xlsm
BrownBoy
If happy, mark "SOVLED" & add to "REP"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks