Help with Formula

[Joefried]

Hi
thanks for looking at my question

i need help with filling in the following Blank Spot

so far i have this:

=IF(A18="(blank)","",IF(A18="","",VLOOKUP(A:A,'Sheet 2'!C:J,8,FALSE)*C18))

however i would like if the answer is 0.00 continue to look until you find something that's at least 0.01 unless there is no

Best Regards
Joe

 

[Joefried]

http://www.mrexcel.com/forum/showthread.php?p=2831251#post2831251

 

[prajul89]

sir can you help me for generates samples sets in excel plz plz help me my set is consists six integers and it has 720 combination to write sample set i cant understand how can i generate sample like my set={1,2,3,4,5,6} and i have to make 720 combination like {6,5,4,3,2,1} plz help me to genrates these sample set on excel 2007 i will be very thankful to you.i m waiting for your reply........as sooooooon as possible plz i have no enough time for my assignment

take care

Sub Test()
r = 1
For num = 123456 To 666666
Application.StatusBar = num
Cells(1, 2).Formula = "=ISNUMBER(FIND(7," & num & "))"
Cells(2, 2).Formula = "=ISNUMBER(FIND(8," & num & "))"
Cells(3, 2).Formula = "=ISNUMBER(FIND(9," & num & "))"
Cells(4, 2).Formula = "=ISNUMBER(FIND(0," & num & "))"
If Cells(1, 2).Value = True Then GoTo nextnum:
If Cells(2, 2).Value = True Then GoTo nextnum:
If Cells(3, 2).Value = True Then GoTo nextnum:
If Cells(4, 2).Value = True Then GoTo nextnum:
Cells(r, 1).Value = num
r = r + 1
nextnum:
Next
Application.StatusBar = False
End Sub

This would do what you want put this in your Module and run it.
don't worry it will take almost 5 mins to run wait for it to fininsh

 

[sonumm]

thanx for your concern but i actually need such a combination 1 cell contain one digit and other sample will like this randon sample without repetation plz is it possible ???i hope you can help me i will be very thankful to you


1 2 3 4 5 6
1 2 3 4 6 5
1 2 3 5 4 6
1 2 3 5 6 4
1 2 3 6 5 4
1 2 3 6 4 5
1 2 4 3 5 6
1 2 4 3 6 5
1 2 4 5 3 6
1 2 4 5 6 3
1 2 4 6 3 5
1 2 4 6 5 3
1 2 5 3 4 6
1 2 5 3 6 4
1 2 5 4 3 6
1 2 5 4 6 3
1 2 5 6 3 4
1 2 5 6 4 3
1 2 6 3 4 5
1 2 6 3 5 4
..........till 720 combinations

 

[Joefried]

Try this array formula**:

=INDEX(B2:B7,MATCH(1,IF(A2:A7="abc",IF(B2:B7<>0,1)),0))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
__________________
.
Biff
Microsoft MVP - Excel

Using Excel 2002, 2007
KISS - Keep It Simple Stupid

 

[sonumm]

thank you Prajul sir
you realy helpful but i cant understand the algorithm thanx once again you give me ur quality time

 

[sonumm]

for Joe sir

sir can plz send me sheet of excel where this formula is working for 720 combination or samples i will be very thankful to you
best regards