If condition for multi selection

[alaboudy]

hello every one
I just want to share with you my small project I am thinking how I can provide solution for it

as you see in the attachments 2 pictures for 2 work sheets in same work book

WS2.JPG

WS1.JPG

what I want to do to fill WS1 with information that based in WS2 but how ?

so the condition that I am trying to do it is if (T4) in WS2 = BGC and if (G4) in WS2 = 24:00 then fill the raw 3 in WS1 with the information in raw4 in WS2 and if the 24:00 is not available select the less than 24:00 and fill the raw with information and it keep looping for 16 cell or raw.

[Glenn Kennedy]

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential information is removed first!!

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[alaboudy]

thank you
the example in the attachment

[alaboudy]

anyone????????

[JeteMc]

What about a Pivot Table?
Let us know if you have any questions.

[alaboudy]

What about a Pivot Table?
Let us know if you have any questions.

thank you JeteMc for your replay
I know how to do it with PT but I want to use if function , because every day I have different data I paste it in sheet 1 and want in sheet 2 to analyse it by code and hours.

[Glenn Kennedy]

I do not understand what you mean by "and if the 24:00 is not available select the less than 24:00 and fill the raw with information and it keep looping for 16 cell or raw
. Unfortunately, you did not address point 2 in my earlier post (which was even in BOLD to draw your attention to it!!!)

However, does this array formula, copied across and down, do what you want:

=IFERROR(INDEX(Sheet2!E:E,SMALL(IF(Sheet2!$I$2:$I$34="BGC",ROW()),ROWS(D$2:D6))),"")

If this is not what you want, please explain again AND INCLUDE YOUR EXPECTED RESULT.

Array Formulae are a little different from ordinary formulae in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly brackets { } - or "curly braces" for those of you in the USA, or "flower brackets" for those of you in India - appear around the outside of your formula. If you do not use CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly brackets yourself - it won't work...