# Search:

Type: Posts; User: aqeelnokia99; Keyword(s):

Page 1 of 3 1

1. ## Thread: Find most match row #

by aqeelnokia99
Replies
13
Views
265

### Re: Find most match row #

i using =TRIM(IF(I2<>INDEX(B2:B7,\$H\$2),I\$1&" ","")&IF(J2<>INDEX(C2:C7,\$H\$2),J\$1&" ","")&IF(K2<>INDEX(D2:D7,\$H\$2),K\$1&" ","")&IF(L2<>INDEX(E2:E7,\$H\$2),L\$1&" ","")&IF(M2<>INDEX(F2:F7,\$H\$2),M\$1&" ",""))...
2. ## Thread: Find most match row #

by aqeelnokia99
Replies
13
Views
265

### Re: Find most match row #

formula is working very well thanks u very very much :)
3. ## Thread: Find most match row #

by aqeelnokia99
Replies
13
Views
265

### Re: Find most match row #

ithink its work easy =TRIM(IF(I2<>INDEX(B2:B7,\$H\$2),I\$1&" ","")&IF(J2<>INDEX(C2:C7,\$H\$2),J\$1&" ","")&IF(K2<>INDEX(D2:D7,\$H\$2),K\$1&" ","")&IF(L2<>INDEX(E2:E7,\$H\$2),L\$1&"...
4. ## Thread: Find most match row #

by aqeelnokia99
Replies
13
Views
265

### Re: Find most match row #

hi i have 1 more issue that my Data colom and and formula sheet colom not in like that i post its like 30 coloms and i verify about 10 colom thats are not on togather is this formula work on ?...
5. ## Thread: Find most match row #

by aqeelnokia99
Replies
13
Views
265

### Re: Find most match row #

Its Working Thanks u very very much :cool:
6. ## Thread: Find most match row #

by aqeelnokia99
Replies
13
Views
265

### Re: Find most match row #

Thanks u very much now i have Most match Row #that is 3 now i want what is not match in row 3 in my case in row 3 size not match so i want Result (3 "Size")
7. ## Thread: Find most match row #

by aqeelnokia99
Replies
13
Views
265

### Re: Find most match row #

i have data like this
<style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } ...
8. ## Thread: Find most match row #

by aqeelnokia99
Replies
13
Views
265

### Find most match row #

Hello i try to find most match row # in a array formula i have 2 sheet with same coloms name like i post down i make a formula like Po sheet 1 = all PO row in sheet 2 and qty sheet 1=all Qty in sheet...
9. ## Thread: Conditional Formatting Formula

by aqeelnokia99
Replies
1
Views
77

### Re: Conditional Formatting Formula

can u explane a little bit more dont understand question
10. ## Thread: Remove the value if condition meet

by aqeelnokia99
Replies
26
Views
718

### Re: Remove the value if condition meet

u just simply put this formula in DB and drage them until HB colom its total 105 colom as u have copy them down to end
=IF(SUMPRODUCT(A2:A\$17)=0,"",A2)
11. ## Thread: Remove the value if condition meet

by aqeelnokia99
Replies
26
Views
718

### Re: Remove the value if condition meet

u can also use this its batter for u
=IF(SUM(A2:\$A\$17)=0,"",A2)
12. ## Thread: Remove the value if condition meet

by aqeelnokia99
Replies
26
Views
718

### Re: Remove the value if condition meet

1 more
=IF(SUMPRODUCT(A2:\$A\$17)=0,"",A2)
13. ## Thread: Remove the value if condition meet

by aqeelnokia99
Replies
26
Views
718

### Re: Remove the value if condition meet

=if(and(a2=0,a3=0,a4=0),"",a2)
14. ## Thread: Remove the value if condition meet

by aqeelnokia99
Replies
26
Views
718

### Re: Remove the value if condition meet

pllease share more your data and what u want ?? u want to remve only 0 after 7 and u have multipul 7 in colom a and how maany 0 are after 7 in colom A please describe in details
15. ## Thread: Remove the value if condition meet

by aqeelnokia99
Replies
26
Views
718

### Re: Remove the value if condition meet

REQ CONTROL + **** + enter
=IFERROR(INDEX(\$A\$1:\$A\$10,SMALL(IF(\$A\$2:\$A\$10<>0=TRUE,ROW(\$A\$2:\$A\$10),""),ROWS(\$B\$1:B1))),"")
16. ## Thread: Remove the value if condition meet

by aqeelnokia99
Replies
26
Views
718

### Re: Remove the value if condition meet

Try this in b2
=IFERROR(INDEX(\$A\$1:\$A\$10,AGGREGATE(15,6,ROW(\$A\$2:\$A\$10)/(\$A\$2:\$A\$10<>0),ROWS(\$B\$1:B1))),"")
17. ## Thread: Remove the value if condition meet

by aqeelnokia99
Replies
26
Views
718

### Re: Remove the value if condition meet

my be offcie 2007 not suport AGGREGATE function wait i try to make a arry formula for u
18. ## Thread: Remove the value if condition meet

by aqeelnokia99
Replies
26
Views
718

### Re: Remove the value if condition meet

put formula in b2 and your working colom is A
19. ## Thread: Remove the value if condition meet

by aqeelnokia99
Replies
26
Views
718

### Re: Remove the value if condition meet

<style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { ...
20. ## Thread: Conditional Formatting - change cell colour and and adding text

by aqeelnokia99
Replies
5
Views
89

### Re: Conditional Formatting - change cell colour and and adding text

in conditnal formating work based on True and Fales or 0 And 1 u can use
like =AND(\$K\$11<\$K\$10,\$A1="Red")
21. ## Thread: Help to correct formula

by aqeelnokia99
Replies
3
Views
99

### Re: Help to correct formula

in first formula u try to find value G03654 and in second u find G01014 so your formula is ok check your data my not have start value G01014
22. ## Thread: devide lot by qty value

by aqeelnokia99
Replies
2
Views
193

### Re: devide lot by qty value

i was upload image lol dont know whre he gone ok i update data in new post make again
23. ## Thread: devide lot by qty value

by aqeelnokia99
Replies
2
Views
193

### devide lot by qty value

hello All . i have a question i have a table with name po and qty and lot
i need result lot how like i post image in image i give fist lot until his lot vale equal or grater then his total then pick...
24. ## Thread: replace second : character with ?? characters with macro

by aqeelnokia99
Replies
5
Views
164

### Re: replace second : character with ?? characters with macro

=substitute(a1,":","??",2)
25. ## Thread: Sumproduct + Isnumber(search) ?

by aqeelnokia99
Replies
4
Views
289

### Re: Sumproduct + Isnumber(search) ?

=SUMPRODUCT(ISNUMBER(SEARCH("CREDITCARD",\$A\$1:\$A\$5))*(\$B\$1:\$B\$5))