need assistance with sorting a list of numbers

  • Thread starter Thread starter al
  • Start date Start date
A

al

I've tried to achieve this problem with formulas and lookups and if
statements and conditinal formatting however was not able to achieve
desired results, so asking for help since I am not good with XL
marcros..if someone can start me up I can navigate myself..

There is a list.. say of numbers and there is a possiblity that
numbers will be repeats like:
12345 fail
12345 fail
12345 pass
11111 fail
11111 pass
22222 pass
33333 fail
33333 fail
44444 pass

I want to read say A1 (numbers) disregard the repeats and put info A2
beside it
12345 fail fail pass
11111 fail pass
22222 pass
33333 fail pass
44444 pass

if anyone can help out it will be gr8ly appreciated..
 
Hi
not quite what you're looking for but you may consider
using a pivot table for creating a report like
number fail pass
1234 3 1
5678 1 2
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Concatenate with line breaks but ignore blank cells 3
data sorting question 5
Sorting 1
Changing Space Between Files while Attaching 1
Working on segments of data from within a list 1
Carrying out calculations on segments of data from within a workbo 1
Import data into Excel sheet from CSV File 3
Lookup and Reference Lists 1

Back
Top