Put this on C7 and copied cross and down
=IF(AND($B7<=C$5,$B7>=C$6),$B7,"")
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
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 & 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 & 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)))