• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. M

    If + Offset

    arifanmol, good morning. Try this formula to meet your new exact request. =IF(COUNTIF(A1:A2,"H"), "accepted", "rejected") ------------------------------------------------------------------------------------------------------------------------ Please do not use the same post to ask for...
  2. M

    If + Offset

    arifanmol, Good morning. Try to put in A4 --> =IF(D7=4, OFFSET(D6,-1,0), "Nothing") The "FALSE" is appearing because what to do is missing in the second argument of the IF function. I put the word Nothing to fill in the missing argument. Please, tell us if it is what you need. have a nice day!
  3. M

    How to pull recent data in excel?

    FauzanOmar, Good morning If by any chance you still haven't solved your question, maybe these formulas will help. I don't think they're ideal, but they do the trick for now. B12 --> =INDEX(C6:C7; CORRESP(C10; B6:B7; 0)) C12 --> =MAX(INDIRECT("D" & (5 + MATCH(C10; B6:B7; 0)) & ":J" & (5 +...
  4. M

    IF/AND/OR Statement

    badger, Good morning. Is this kind of formula that are you looking for? C1 --> =IF(AND(A1<>"";B1<>""); IF(A1="Y"; IF(B1="Y"; 1; 2); IF(B1="N"; 3; 4)); "") Use the separator symbol as your operational system: " ; " or " , " Please, tell us, if this solves your rquestion. I hope it helps.
  5. M

    Different column formula

    stormina, Good evening. Thanks for the feedback.:) I'm glad to have helped you.
  6. M

    Different column formula

    stormina, good morning. Maybe a variation can help. =VLOOKUP($A3; 'data 1'!$A$3:$N$5; MATCH(C$1; 'data 1'!$A$1:$N$1 ;0) + 3; FALSE) Does this meet your need? Hope it helps
  7. M

    Different column formula

    stormania, Good morning. If your columns are fixed and the data in column A is unique, maybe the VLOOKUP function can help you. It's a simple formula but it works. Please let us know if this is what you want. Hope this helps.
  8. M

    Allowed to add only specific data

    Pampos, Good morning. Have you tried using Data Validation? It works exactly as you need it. And it can even present an error message to the user if he tries to type information instead of just choosing a default data from the list. Please, let us know if this is what you wanted. Hope...
  9. M

    CountIFS with three different criteria

    davidb73, Good morning. Take a look at your example with my suggested formulas. Please, tell us if it worked for you. I hope it helps.
  10. M

    how to find blank cells

    m9vukyem, Good morning. "...please tell me how to a way to find empty cells..." You requested a way to identify empty cells and the submitted suggestion does just that. Now you are mentioning invisible characters in empty cells. Your example did not contain any such cases. Please, send us...
  11. M

    how to find blank cells

    m9vukyem, Good evening. Try to use Conditional Format. Select A1:A183 ...> Conditional Formatting ...> New Rule ...> Select: Use a formula to determine wich cells to format ...> Rule formula box: =$A1="" ...> Click Format button ...> Choose Fill color as desired ...> OK Please, tell us if...
  12. M

    Conditional Formatting

    cmf735, Good afternoon. Thanks for the feedback. I'm glad I was able to help you. Have a great week.
  13. M

    Conditional Formatting

    cmf735, Good morning. Try to do this: a) Highlight cells in Column B and C that are the same date in column A Select B2:C100 ...> Conditional Formatting ...> New Rule ...> Select: Use a formula to determine wich cells to format ...> Rule formula box: =AND($A2=$B2;$A2=$C2) ...> Click...
  14. M

    If formula required

    pallu, Good morning. You're asking for an IF Function solution. Try this one: D8 --> =IF(C8>80;4000;IF(C8>70;3000;IF(C8>60;2000;IF(C8>50;1000;0)))) BUT, if you can modify your table, you will have the benefit of using the VLOOKUP function. See the example I created for you. Was this what...
  15. M

    If condition

    Arup Dutta Chowdhury, Good afternoon. Try to use: E2 --> =IF(--LEFT(D2;1)>3;">3 years";IF(--LEFT(D2;1)=3;"2-3 years";IF(--LEFT(D2;1)>=1;"1-2 years";0))) Please, tell us if it worked as you desire. I hope it helps.
  16. M

    Last Description needed for every code

    Tom22, Good afternoon. Thanks for the feedback. Glad to help you.
  17. M

    Last Description needed for every code

    Tom22, Good morning. Try to use: Selecting CODE: D2 --> =IFERROR(INDEX($A$2:$A$67;MATCH(0;INDEX(COUNTIF($D$1:D1;$A$2:$A$67); ); ));"") Selecting DESCRP: E2 --> =LOOKUP(2;1/($A$2:$A$67=D2);$B$2:$B$67) Please, tell us if it worked for you. I hope it helps.
  18. M

    Currency Converter Calculator

    ChaCha90, Good morning. You're welcome. Thanks for feedback, Glad to help you.
  19. M

    Currency Converter Calculator

    ChaCha90, Good evening. Try to use: Sheet --> 'Currency Converter Calculator' D4 --> =VLOOKUP(B3;'Currency Prices'!$C$2:$D$101;2;FALSE) * B4 / VLOOKUP(D3;'Currency Prices'!$C$2:$D$101;2;FALSE) I'm using an old Excel version at this moment. I hope it helps.
  20. M

    my formula correction for bank statement desired words

    GVN KUMAR, Good morning. Your data has no pattern for a formula to work directly. Please, explain to us what is your real need for results in these cases. Below I show 8 examples of your data. Please, what would be the result expected by you? 1) I-W CHQ RETURN-MICR-CHITRA TEXTILES 2) CHQ...
  21. M

    if and functions to compute Professional Tax

    excelnovice2000, Good morning. You're welcome. Thanks for the feedback and Glad to help you.
  22. M

    if and functions to compute Professional Tax

    excelnovice2000, Good morning. Try to use: IF(A3<15000, 0, IF(AND(A3>=15000,A3<=20000), 150, 200)) Please, tell us if it's what you need. I hope it helps.
  23. M

    How to increase indent level of exported data?

    mpolo954, Good afternoon. Thanks for the feedback. Very pleased to have helped you.
  24. M

    How to increase indent level of exported data?

    mpolo954, Good morning. Will the indentation serve as a visual reference or will it have another function? If it is for visual reference, I think identification with more contrast is feasible. Use the formula in cell C2: =SUBSTITUTE(C2; C2; REPT("............|"; B2-1) & C2) ....... I used a...
  25. M

    How to increase indent level of exported data?

    mpolo954, Good evening. Maybe I'm missing something but this indentation in column C did you manage to put the spaces manually, for demonstration? If so a have a modest suggestion. a) Select B column b) FIND-REPLACE: space by nothing. Them all of texts will left-aligned equal. c) Cell C2...
Back
Top