It will be delightful
1 Like
Help required from Excel Guru!!! 
I have a spreadsheet with 2 coulmns - Column A Contains Account Numbers, Coulmn B contains different Information pertaing to the accounts.
The account #'s in A can be duplicated many times and the information in B can duplicated many times.
What i need is - list of account ID’s that just one type of the information contained in B
Example:
10 Limerick
10 Cork
10 Clare
20 Clare
20 Clare
30 Limerick
30 Limerick
40 Dublin
I want to get account that just “likes” Limerick ie 30
You want to get values from A that are unique to a specific value in B?
That would be correct!! And a very good way of putting it!!
Don’t be bothering IT folk with this, it’s a question for Excel jockeys like @Bandage and @Julio_Geordio
3 Likes
ill need more info than that mate
So you just want all the limericks in column two? A filter would do that?
No, he wants the values in A that are only equal to one value in B
So he wants to take the duplicates out of A?
That will give all Limerick’s. I want accounts where they have Just limerick!!
Vlookup is probably what you need. If not pivot tables. I am unsure exactly what you are trying to do.
So accounts from A that only correspond to Limerick in B and nothing else?
Nope because that won’t tell me if the an account is solely limerick!!
Pivot table could do it!! Never thought of that!
Yep!!
Right remove duplicates from A and then filter B
Limerick is obviously code for being in arrears and fuck all hope of ever being sorted.
1 Like
Promising accounts that failed to deliver
3 Likes
Can you not just sort them?
So I did this and guess What?
My Eir 4G modem arrived yesterday (ordered before testing signal with a cell phone). Despite having nil signal on the mobile I’m getting 10G downloads speeds off it.
##hashtaggamechanger #changingmylifeinwaysineverthoughtpossible #browsingtheinternetisnowalittletraditionofmine