Posts by azumi

Put this on C7 and copied cross and down

=IF(AND($B7<=C$5,$B7>=C$6),$B7,"")

Hope this helps

Re: Vlookup using wildcard for fetching the data

Hope this helps

cheers

Re: Extracting specific data from export file

Hope this helps, please see the attach file

Azumi

Re: last 5 records

Don't send us an image try to upload your excel file and explain your desired results, click on "Go Advanced" button and find paperclip image button to upload your file

Re: Need help making a list in excel

Perhaps something like this?

Re: Find a Row and return value in a certain column value.

Don't upload an image, no one will answer it, try to upload your excel file, click on "Go Advanced" button and look down for text button named "Manage Attachments" to upload the file

Re: Formula to sum by criteria

Try with SUMIFS function

=SUMIFS(F8:F15,D8:D15,D3,E8:E15,E2)

Re: Index &amp; match

I'm revise the formula

=IF(E8=ROWS($A$1:A1),IF(D8>0,D8*B8,A8*INDEX($H$8:$H$16,E8)))

Re: Index &amp; match

Maybe, put in C8 and copied down

=IF(E8=ROWS($A$1:A1),IF(D8>0,D8*B8,A8*H8))

Re: SUM with letters

Try this array formula

=SUM(IF(ISNUMBER(SEARCH("w",S6:S7)),SUBSTITUTE(LOWER(S6:S7),"w","")+0))&"w"

put this on a cell then press F2 button to open the formula then hit/press all together CTRL+SHIFT+ENTER

Re: Trying to retrieve Data over multiple Rows and Columns

Try to upload your sample excel workbooj for better understanding

Re: Associating a date with specific group of numbers

Put in B2 on Sheet1 and copied down

=INDEX($D$2:$D$14,INT((ROW(A1)-1)/6)+1)

I have data like this:

A
A B
A B C
A B C D
A B C D E

I need to right alignment like this :
A
A B
A B C
A B C D
A B C D E

I need do this with formula, help me pls

Re: Lookup Values in any column

Put in B1

=IFERROR(INDEX(A2:F11,AGGREGATE(15,6,ROW($1:$14)/(A2:F11=A1),1),AGGREGATE(15,6,COLUMN($A:$F)/(A2:F11=A1),1)+1),"")

Re: Return Nth Result on a Multiple Criteria Index Match

try to uoload your sample file and i'll will show it to you

regards

Re: Reverse Search

Something like this?

Re: Lookup Values in any column

Click on "Go Advanced" button and find Paperclip Image button to attach the file

Re: How to countifs dates between todays date and 7 days ago

Nothing wrong with the formula, maybe your formulas calculation setting set to manual, try change to "automatic"

Steps
1. Click on "Formulas" tab
2. Click "Calculation Options"
3. And choose "Automatic"

Re: sumifs and match ???

Put in cell S2 :

=SUMPRODUCT(INDEX(B2:P13,,MATCH(R2,B1:P1,0)))