Search results

Narayan, thank you for that formula, it works perfectly. Made my life so much easier. Thanks once again.

Hello, need ur help AGAIN!!!! If I have a list of numbers in column A1:A10 1,2,3,4,5,6,7,8,9,10 and in the next column (B1:B10) I have A,B,C,D,E,F,G,H,I,J. If I type in cell D3 '4', then I want to appear in D4 'D'. I have tried using the match and column formulas but to no great success. Thank...

Thanks for your efforts guys and the humour too! Tried SirJB7's formula as I cannot speak another language!!!! This threw up a 'may not use unions, intersections or array constants for Data Validation Criteria'. I then took out the unions and there is an error with the formula. i will try to...

All, thanks for your replies. i tried the = before the formula that Faseeh proposed and it worked. However, can that be rolled out from say a3:a1003? Thank you.

Faseeh, Thank you for the reply. I tried it in D6 as a custom data validation but it did not work. It came up with an error. I want to input say '12/345'. This means there will be 6 keystrokes to input the cell value, not a case of inputting 12345 and then it being changed to 123/45. I hope...

Hello, I want each cell in a column to have a specific format of two numbers, a forward slash and then three numbers (##/###). I want the cell input to be validated against this format and issue an error if the input does not match. Thank you for your time.