ok col a contains a list of numbers (non unique) col b has text (non unique) but repeats
what id like is somthing to find number in col a and count any incidence of ....
oh sod it i'm in the realms of 'water cooler' dodgy questions/ see attached
ok col a contains a list of numbers (non unique) col b has text (non unique) but repeats
what id like is somthing to find number in col a and count any incidence of ....
oh sod it i'm in the realms of 'water cooler' dodgy questions/ see attached
Maybe =SUMPRODUCT( (A1:A19=C1) * (B1:B19={"frog","pig","toad"}) ) >= 1
yep that's it
thanx..
now off to another thread to impress/demonstrate how clever i am
Last edited by martindwilson; 09-04-2008 at 07:37 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks