-
I use Excel in real estate and personal goal setting and run into questions that aren't evident to me.. like 'how to get around circular formula errors .. pair prior ttl today run ttl pair prior ttl total run ttl A/U 100 10 110 E/U 10 7 17 G/U 50 2 52 N/U 10 8 18 E/G 200 3 203 U/C 10 9 19 E/C...
-
Hi Alan, Many thanks for your prompt reply and the idea contained therein. Very useful, and I will use your idea coupled with the other one received, as they both work for me. Thanks for your time in this matter. Best regards, Graham
-
Hi Alex, Many thanks for your prompt reply and the idea contained therein. Very useful, and I will use your idea coupled with the other one received, as they both work for me. Thanks for your time in this matter. Best regards, Graham
-
Hi, Hope that somebody is able to help me to ensure that people complete a detailed spread sheet with ALL data, as this is a compliance requirement. Trying to keep it simple, we have a screen with Name, Position, Date, Pest (we are a pest control company), question and comment text, which we will number...
-
Spindrift I'm sure David's answer is the way to go if you want to validate data. To complete the answer, Access has 'placeholders', Excel does not. You could also use a Worksheet_Change() event to validate the input into a cell and if you could validate as a date (4, 5 or six numbers...
-
Can please someone send me the workings in a excel sheet which shows how to create a bell shaped graph. I have 500 data points and i'm struggling to show standard deviation in the form of a bell graph. You help will be appriciated. My email address is : vanse@hotmail.co.uk Thanks
-
Javan Unfortunately your table has been truncated as it is too wide for the window. I believe we can use data validation here. Set up your list somewhere and then use Data>Validation.. and select 'list' from the 'allow' dropdown (You could type a comma seperated list in the 'source'...