Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to make an function to list all the same records
Good day!
I want to make a function formula instructing to list down all the same records based on the inputed by the user, the thing I can't solve. Below is the table example. Table: A B C D 1 ID NUMBER NAME Course Points 2 1000218 Mandy BS Computer Science 5 3 1000214 Jehu BS Nursing 7 4 1000215 Hernan Civil Engineering 8 5 1000216 Jomar Information Technology 2 6 1000217 Apple Associate in C.S. 4 7 1000218 Mandy BS Computer Science 9 8 1000219 Ermin BS Nursing 7 9 1000218 Mandy BS Computer Science 8 10 1000221 Jay Civil Engineering 3 Sample output result that i want to come out: input id number: 1000218 1000218 Mandy BS Computer Science 5 1000218 Mandy BS Computer Science 9 1000218 Mandy BS Computer Science 8 Is this possible to do? Your help is very much appreciated. Jared |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make the true return a drop down list in the IF function? | Excel Worksheet Functions | |||
Can VLookup function find and list multiple records? | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
how to use the Prob function in a list of averages to find the le | Excel Worksheet Functions | |||
Creating Drop Down boxes with the List function... | Excel Discussion (Misc queries) |