Column A has an entry everytime I make a sale. Column F has how many I've bought. I need to know if there is a way to have column H lookup the ID from F and count how many times it shows up in A..
I've attached a test page.
thanks..
Column A has an entry everytime I make a sale. Column F has how many I've bought. I need to know if there is a way to have column H lookup the ID from F and count how many times it shows up in A..
I've attached a test page.
thanks..
Last edited by budchevy; 05-09-2011 at 03:07 PM.
Is this what you are looking for?
=COUNTIF($A$2:$A$17,F2)
copy down
Alan
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thanks, that worked..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks