-
Operating system is XP Professional Excel version 2007 I am using drop down lists for users to enter data into cells. When the user clicks the down arrow associated with the cell list box the list appears but is always automatically scrolled by Excel to the bottom of the list. This requires the user...
-
What is the easiest way to compare two sets of data and identify both (1) the records that appear in both data sets, and (2) those that are uniquely in each. Example: Assume that I have 2 different spreadsheets with address information which I believe have a large number of entries in common. I need...
-
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'...