# Posts by azumi

• ## Find, match, plot and fill values in a given range.

Put this on C7 and copied cross and down

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

• ## Rank formula that returns an alpha rank if more than one value has the same rank?

Hope this helps

• ## Vlookup using wildcard for fetching the data

Re: Vlookup using wildcard for fetching the data

Hope this helps

cheers

• ## Extracting specific data from export file

Re: Extracting specific data from export file

Hope this helps, please see the attach file

Azumi

• ## last 5 records

Re: last 5 records

• ## Need help making a list in excel

Re: Need help making a list in excel

Perhaps something like this?

• ## Find a Row and return value in a certain column value.

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

• ## Formula to sum by criteria

Re: Formula to sum by criteria

Try with SUMIFS function

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

• ## Index & match

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

• ## Index & match

Re: Index &amp; match

Maybe, put in C8 and copied down

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

• ## SUM with letters

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

• ## Trying to retrieve Data over multiple Rows and Columns

Re: Trying to retrieve Data over multiple Rows and Columns

• ## Associating a date with specific group of numbers

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)

• ## Need To Alignment to The Right

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

• ## Lookup Values in any column

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

• ## Return Nth Result on a Multiple Criteria Index Match

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

• ## Reverse Search

Re: Reverse Search

Something like this?

• ## Lookup Values in any column

Re: Lookup Values in any column

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

• ## How to countifs dates between todays date and 7 days ago

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"

• ## sumifs and match ???

Re: sumifs and match ???

Put in cell S2 :

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