Recent content by Marcilio

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...

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!

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 +...

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.

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

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

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.

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...

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.

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...

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...

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

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...

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...

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.