# Posts by azumi

Put this on C7 and copied cross and down

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

Re: Vlookup using wildcard for fetching the data

Hope this helps

cheers

## Files

Re: Extracting specific data from export file

Hope this helps, please see the attach file

Azumi

## Files

Re: last 5 records

Re: Need help making a list in excel

Perhaps something like this?

## Files

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

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

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),"")

## Files

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?

## Files

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)))