for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

1 lurker | 101 watchers

SPR Mar 2022 1:59pm, 22 Mar 2022 36,487 posts	0 SPR If you click the X Grep, you can just see kittens rather than have to deal with Glenn's 'difficult' questions
GlennR Mar 2022 2:04pm, 22 Mar 2022 62,622 posts	0 GlennR
ChrisHB Mar 2022 2:09pm, 22 Mar 2022 21,604 posts	0 ChrisHB If I don't understand pivot tables, does that make me an expert? Don't answer that.
GlennR Mar 2022 2:10pm, 22 Mar 2022 62,625 posts	0 GlennR Understanding them is fine. Using them is to sell ones soul to Satan.
Diogenes Mar 2022 2:15pm, 22 Mar 2022 68,231 posts	0 Diogenes If the money's good...
SPR Mar 2022 2:21pm, 22 Mar 2022 36,488 posts	0 SPR It's ironic that I've used pivot tables quite a lot recently in conjunction with tables so that amateurs can use Excel to produce quick summaries of certain data.
larkim Mar 2022 4:00pm, 22 Mar 2022 17,436 posts	0 larkim How does the countif work for that problem? Is this the way? If data is:- A A B B C D E E R T T B B T T R Then on a separate sheet (for example) =COUNTIF(OtherSheet!$A1:$H1,A1)>1 returns TRUE if it matches, FALSE if it is unique on that row?
run free Mar 2022 4:40pm, 22 Mar 2022 4,942 posts	0 run free Yes can do. Also can use Conditional Formatting to show where dups are in the data I use PivotTables a lot, especially if you want an interactive dashboard and perfect for handling OLAP data
larkim Mar 2022 4:46pm, 22 Mar 2022 17,439 posts	0 larkim Conditional formatting would struggle with the row by row duplication though wouldn't it? Or is it possible for the conditional formatting to review on a row y row basis (with a countif formula perhaps?)
larkim Mar 2022 4:48pm, 22 Mar 2022 17,440 posts	0 larkim [Edit - just made it work. That's quite fun]