for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers

SPR Mar 2022 1:59pm, 22 Mar 2022 36,487 posts	Quote Pin 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	Quote Pin GlennR
ChrisHB Mar 2022 2:09pm, 22 Mar 2022 21,604 posts	Quote Pin 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	Quote Pin 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	Quote Pin Diogenes If the money's good...
SPR Mar 2022 2:21pm, 22 Mar 2022 36,488 posts	Quote Pin 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	Quote Pin 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	Quote Pin 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	Quote Pin 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	Quote Pin larkim [Edit - just made it work. That's quite fun]