-
Today's author: Sam Radakovitz, a Program Manager on the Excel team that enjoys creating VBA applications in Excel. A bit ago, Joseph had a blog post about community clips on OfficeLabs.com , so for this post, I wanted to take advantage of the video demonstration and do the post via community clips...
-
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
-
Recently I posted an article discussing how PivotTables can be used on Excel Services to mimick the Data Validation feature . The author, Dany Hoter, sent me a copy of the file he used in the example screen shots and I never got around to posting it for our readers. Here's a short description of...
-
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'...
-
Excel has a feature called Data Validation that controls the possible values a user might enter into a cell or a range of cells. As you can see there are many options for validating data entry. The most popular is probably validating against a list of values. The list can be included in the validation...