From Table Find repeated values of multiple columns of data

**choletseng** · 10-18-2021, 05:12 AM

Example : Fruits sold at the same time in four stores "ORANGE"

Can someone please help me ? It would be much appreciated. Thanks in advance

**davsth** · 10-18-2021, 05:39 AM

If your data was store, fruit, a simple pivot would give you

fruit, count

the list in the order you seek. to get the anwer form the datai n the shape it currently is is will be a complex formula or vba, or possibly power pivot which I know very little about!

**RaulSerg** · 10-18-2021, 05:41 AM

Try the attached.

Regards

**wk9128** · 10-18-2021, 08:04 AM

Cell G2 Array formula , Drag down and across

Try this !r0c00, if can not try r0c00

Formula:

Please Login or Register  to view this content.

**choletseng** · 10-19-2021, 07:37 AM

Problem solved, You all are awesome

wk9128,RaulSerg .Thanks you very much

**wk9128** · 10-19-2021, 10:07 PM

@choletseng You're Welcome. Glad to help . Thank You for the feedback and rep.

From Table Find repeated values of multiple columns of data

LinkBack

Thread Tools

Rate This Thread

Display

From Table Find repeated values of multiple columns of data

Re: From Table Find repeated values of multiple columns of data

Re: From Table Find repeated values of multiple columns of data

Re: From Table Find repeated values of multiple columns of data

Re: From Table Find repeated values of multiple columns of data

Re: From Table Find repeated values of multiple columns of data

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] highlighting repeated for specific values on multiple columns not rows

[SOLVED] Creating A Table Based On Data With Repeated Lookup Values

i am trying find repeated values in the column but it is finding only one repeated values

[SOLVED] Conditional Formatting: Find When Values in 3 Columns Are Repeated in Rows

[SOLVED] Append data to repeated values with a fixed array to be repeated on value change

Macro for Repeated Values from Multiple Columns

[SOLVED] Find multiple repeated values in a Pivot Table

Bookmarks

Bookmarks

Posting Permissions