ST Alpha - "Excel help needed... I can't seem to find a good way to ask Google" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 161

Excel help needed... I can't seem to find a good way to ask Google

Posted by Dano (aka dano) Feb 7 '19, 16:36

I have two columns on a spreadsheet that I'm concerned with.

Column A and Column E
The same information is repeated in multiple rows in each column. I want to find instances where there are differences in Column E for the same value in Column A. For example below I'd like to call out the YYYYYYYY because it has different values in Column E:

Column A --- Column E
XXXXXXXX 11111111
XXXXXXXX 11111111
XXXXXXXX 11111111
YYYYYYYY 22222222
YYYYYYYY 33333333
YYYYYYYY 22222222
ZZZZZZZZ 22222222
ZZZZZZZZ 22222222

Responses:

Run a pivot table and for each unique value in A, figure out how to divide the sum of E by the count of E. -- (edited) - Super Daddy Princess Feb 7, 17:05 2
- It actually worked! -- (edited) - znufrii Feb 7, 17:27
- (This assumes that E is numbers) -- nm - Super Daddy Princess Feb 7, 17:11
Here's my thought: - Roger More Feb 7, 16:44 3
- spreadsheet solution buddies! -- nm - prayformojo Feb 7, 17:13 1
  - Bump protractors! -- nm - David Feb 7, 17:16
- That may work (you and pfm have the same solution) I’m okay with multiple rows being highlighted. All of the BBBBBBBB rows in my example would be fine -- nm - Dano Feb 7, 16:46
Maybe a pivot table with Rows for A and Values for E using COUNTA to identify A with more than one value. -- nm* - Max Feb 7, 16:41
to evaluate row 5, you could try..... - prayformojo Feb 7, 16:41

Post a message top

Excel help needed... I can't seem to find a good way to ask Google

Replies are disabled on threads older than 7 days.