Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.00 seconds.

  1. 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. Replies
    13
    Views
    265

    Re: Find most match row #

    formula is working very well thanks u very very much :)
  3. 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. 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. Replies
    13
    Views
    265

    Re: Find most match row #

    Its Working Thanks u very very much :cool:
  6. 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. 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. 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. Replies
    1
    Views
    77

    Re: Conditional Formatting Formula

    can u explane a little bit more dont understand question
  10. 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. 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. Replies
    26
    Views
    718

    Re: Remove the value if condition meet

    1 more
    =IF(SUMPRODUCT(A2:$A$17)=0,"",A2)
  13. Replies
    26
    Views
    718

    Re: Remove the value if condition meet

    =if(and(a2=0,a3=0,a4=0),"",a2)
  14. 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. 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. 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. 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. Replies
    26
    Views
    718

    Re: Remove the value if condition meet

    put formula in b2 and your working colom is A
  19. 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. 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. 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. 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. 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. Re: replace second : character with ?? characters with macro

    =substitute(a1,":","??",2)
  25. Replies
    4
    Views
    289

    Re: Sumproduct + Isnumber(search) ?

    =SUMPRODUCT(ISNUMBER(SEARCH("CREDITCARD",$A$1:$A$5))*($B$1:$B$5))
    https://cdn1.imggmi.com/uploads/2019/2/28/95aaf1c352c95c32c124eed239aaed5e-full.png
Results 1 to 25 of 67
Page 1 of 3 1 2 3