Trouble with Dynamic Outputs

[PaulRi]

I'm having trouble with an Excel Database:

http://www.youtube.com/watch?v=dhMTvZXz_SU


Either the rows aren't turning red or the dynamic output isn't showing up, or the results aren't counted!

So frustrating. Please Help.

PR

 

[Smitty]

Please post your example here instead of referring to an outside source. Things like YouTube and file sharing/image sites are blocked for a lot of people, so you're limiting the number of people who might otherwise respond.

 

[PaulRi]

Okay:

I have two tables, A (columns A, B, C) and B (columns E, F, G)
I have Three input fields, one for each column of Table A: INPUT1 (column A1) and INPUT2 (column A2) and INPUT3 (column A3)

I would like to be able to type data into INPUT1 and INPUT2 and INPUT3 and have it locate and count the matching data in table A and output the rows to table B. Of course, any data that is output must meet ALL criteria present in all imput fields, blanks aside. Also, I would like the matching rows in table A to be highlighted red when that row matches the criteria presented.

My code thus far is:

FOR COUNTING:
=COUNTIF(Material_Name,C2)

FIRST CELL OF TABLE B, COLUMN E (EXPANDED TO REST OF TABLE)
=IF(ROWS(V$7:V7)<=$C$4,INDEX(INDIRECT(V$6),SMALL(IF(Material_Name=$C$2,ROW(Material_Name)-ROW($C$7)+1),ROWS(V$7:V7))),"")

Thanks,

PR

PS, that youtube video was uploaded by me - displaying the issues I am having with my own excel sheet. Words can only do so much to help here.

 

[PaulRi]

Does anyone here have a clue?

Wow ... I never would have thought this issue would stump such a large community.

 

[PaulRi]

BTW:

I have made an in depth presentation of the difficulties I am having.


http://www.youtube.com/watch?v=eu8OzkGxW58


Once more, any input would be greatly appreciated.


PR

 

[shg]

I can't hear the audio on your videos, and don't really understand your explanation. However, ...

If the entry in A1 is a filter for the rest of col A, A2 for col B, and A3 for col C, then why not put those in the proper column and use Advanced Filter with criteria?

Or even just AutoFilter?

 

[PaulRi]

I know there are more simple ways of doing this - but I am going to be sorting through tens of thousands of entries in rapid concession. I'm familiar with Filter but filtering manually instead of dynamically would more make it take a LOT longer.

Here is a link to my excel file if you want to take a look:
http://www.filedropper.com/emt211-214finished

Thanks for taking a look at my post, brave soul! : )

PR

 

[PaulRi]

bump!

 

[PaulRi]

bump!