fimding multiple records that match specific criteria

[gelandl]

Hi

I have a spreadsheet that contains several columns and rows or data about learners. I would like to create and additional sheet that allows a user to input a learner's name and surname into criteria boxes and then call up all records on the main spreadsheet that match the criteria.

I do however need it explained stpe by step. I have picked up many formulae that I could use but I dont understand how the formula wa put to gether!

Can anyone please assist me?

Thank
Lynn

[reggie1000]

Hi Lynn,

is this what you are looking for??, i have used the dashboard sheet, using the surname dropdown will bring the records for that individual forward, the list is self expanding so when new individuals are added they are also included.

hope it helps reg

[olasa]

One option is to use an Autofilter - to filter "in the place".
Another option is to use an Advanced Autofilter to create a List on a separate page (it could be evoked by a Macro). Advanced Macro is found under menu: Data, Filter, Advanced Filter...

//Ola

[gelandl]

Hi

The formula Regiie sent is perfect, however when I transcribe it to the actual database, the information is in the wrong rows. For example, instaed of the ID number appearing in the ID column, it shows "PERM".

Is it possible to explain to me how you put the formaul together please? Especially the numbers right at the end.

Thanks

[gelandl]

Hi Reggie

I found that the formula is perfect. However when i try to transcribe it to my actual worksheet it does not work. I have attached a sample fo the actual worksheet using the same sheet titles and columns. Would it be possible for you to write the formulae into this for me please? I dont seem to get how the formula is bulit up and what its part mean.

Sorry if I sound ridiculous!

Thanks

[olasa]

You could just cut and paste the formulas to the right position if they are mixed up in the wrong rows.
//Ola

... if there are no people with the same names, I would also go for the formulas.

[olasa]

I just had a look at the formula and it draws information from row 6. There are numbers there written with white text. The number comes from the column position in the databas (HR Assesment list). You could just change the number and see how the formulas works.
//Ola

[reggie1000]

hi lynn,

i have changed the formula to suit your new sheet.

i have have had to remove some of the work that was in the sheet to get it back to under 100kb for posting.

ta reg

[gelandl]

Once again thanks Reggie you are a star! Just want to check, will this formula pull all records for teh criteria stipulated? Or just the first one?

[reggie1000]

Hi Lynn,

it will do 1000 records in the register form, if you need more just amend the range in the vlookup.

thanks reg

[gelandl]

Hi there

It still does not work, when I change the learners name and Surname to any other name, it only show NA in each column.