Hi,
I have sample data in columns A:D and would like to extract from it to column H the count associated with each country.
The required outcome is in G:H.
Can someone please suggest a formula for column H that will accomplish this?
Thanks!
Hi,
I have sample data in columns A:D and would like to extract from it to column H the count associated with each country.
The required outcome is in G:H.
Can someone please suggest a formula for column H that will accomplish this?
Thanks!
Last edited by andrewc; 06-17-2023 at 05:51 AM.
with Power Query
PRODUCT NAME SALES RANK % UNITED KINGDOM 25UNITED STATES 76SPAIN 17JAPAN 121
With a formula:
Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you both very much!
You are welcome
Have a nice day
If there is an after party, is here a different solution:
Please tryFormula:Please Login or Register to view this content.
You're welcome. Thanks for the rep.
@Hans: that's very neat. Feels a bit like cheating . Anyway, makes my effort look either over-engineered, or just a bit round the houses
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks