Match values on different columns based on criteria

		Microsoft Office Forums > Microsoft Excel > Excel
Match values on different columns based on criteria

FAQ

Thread Tools

Display Modes

glenhmalnv2d1 Match values on different... 02-21-2021, 03:56 AM

p45cal Not especially easy. In the... 02-21-2021, 06:03 AM

glenhmalnv2d1 Thanks a lot for the help!!!... 02-21-2021, 11:34 PM

p45cal 1. You have only 3 distinct... 02-22-2021, 06:25 AM

Pecoflyer Cross posted at Match and... 02-22-2021, 12:18 AM

glenhmalnv2d1 Hi actually you are... 02-28-2021, 05:06 PM

p45cal I can get 2 of the lists you... 03-01-2021, 04:58 AM

ArviLaanemets Not exactly what you asked,... 03-03-2021, 12:46 AM

03-03-2021, 12:46 AM

ArviLaanemets ArviLaanemets is offline

Match values on different columns based on criteria

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 954

Not exactly what you asked, but I think close enough!

You can hide helper columns (ones colored differently) in datatable.
Currently when same city is attached to same name several times, all occurrences are returned, and a city counts for every occurrence. Probably it is possible to ignore multiple occurrences, but this will demand much more time than I'm ready to spend.

Attached Files

Excel question - updated.xlsx (16.3 KB, 9 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create a unique list of values that match a criteria, sorted in order of another criteria	BradRichardson	Excel	2	01-03-2017 12:25 AM
Count unique values that match 2 or more criteria	caeiro01	Excel	1	10-25-2015 02:34 AM
Hide rows in multiple columns based on zero values	Deane	Excel Programming	19	06-23-2015 11:24 PM
transpose values based on mulitple criteria	mlttkw	Excel	1	12-06-2013 02:00 AM
Change values in cells based on criteria	SaneMan	Excel Programming	2	02-02-2012 07:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:57 PM.