Question about Microsoft Office Excel 2003 for PC

Hi Manjee,

There is no formula used in data dropdown list, so it can not be verified as a formula using evaluate formula, trace errors, trace dependents, trace precedents etc.

If you want to create such lists simply:-

- Select input range then goto

data --> validation --> allow, list --> select the list range - To veryfy you can follow the same process

data --> validation --> allow, list ,

now you can see the exact range from where the data is picked.

Zulfikar Ali

ali_zulfikar@yahoo.com

09899780221

Posted on Jan 31, 2009

Formulas don't usually contain data, but display some transformation of data held in cells that do contain the data.

ie cell C3 may have a formula that says "=C1-C2"

Which means that C3 will display the result of the operation of subtracting the content of C2 from the value held in C1"

Clear out only the cells that contain the source values (C1 & C2) and your formula (C3) will remain.

ie cell C3 may have a formula that says "=C1-C2"

Which means that C3 will display the result of the operation of subtracting the content of C2 from the value held in C1"

Clear out only the cells that contain the source values (C1 & C2) and your formula (C3) will remain.

Aug 29, 2014 | Business & Productivity Software

Ok - if your question is "What is Excel" - then the answer is that it is a spreadsheet program that allows you the ability to compute data (usually numbers) for example, pulling together a list of hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools using formulas and functions ... which is a good segwey into my other answer.

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...

In the cell where you want the data to be stored use the =cell formula

for example =CELL("contents",A2). now A2 is where your dropdown list is. put this code where you want the data to be stored.

for example =CELL("contents",A2). now A2 is where your dropdown list is. put this code where you want the data to be stored.

Nov 29, 2009 | Microsoft Excel for PC

You can use cell validation.

Select the cells you want to have the dropdown list.

Press the following keys "alt" "d" "l" and you get a message box.

select List from the drop down.

Now you can type in your list in the blank box separated by commas

Select the cells you want to have the dropdown list.

Press the following keys "alt" "d" "l" and you get a message box.

select List from the drop down.

Now you can type in your list in the blank box separated by commas

Nov 29, 2009 | Microsoft Excel for PC

Add another colum, say D with result of B*C

Do a list of the different cat, and use sumif

For cat 0101 (in cell F1)

formula to put in G1

=sumif($A$1:$A$7000;F1;$D$1:$D$7000) where F1 contain 0101

expand the formula for other cat. (G2, G3, etc)

You can use a assistant to extract the distinct cat from A1:A7000, sorting them and copy the result in F (Menu Data-> Filter -> elaborate filter)

Do a list of the different cat, and use sumif

For cat 0101 (in cell F1)

formula to put in G1

=sumif($A$1:$A$7000;F1;$D$1:$D$7000) where F1 contain 0101

expand the formula for other cat. (G2, G3, etc)

You can use a assistant to extract the distinct cat from A1:A7000, sorting them and copy the result in F (Menu Data-> Filter -> elaborate filter)

Feb 16, 2009 | Microsoft Excel for PC

Would you not be better off with a pivot table ?

To use multiple drop downs - each listing would need to be associated, or have a column that causes a relationship.

When selection 1 is made - a formula will dictate what fields to make visible (available) in the next menu..

you could build a macro in that will 'lift' the formulised data, and 'paste as values' it into a control area that will then give you a definitve second list based purely on the initial drop down.

Hope this makes sense

To use multiple drop downs - each listing would need to be associated, or have a column that causes a relationship.

When selection 1 is made - a formula will dictate what fields to make visible (available) in the next menu..

you could build a macro in that will 'lift' the formulised data, and 'paste as values' it into a control area that will then give you a definitve second list based purely on the initial drop down.

Hope this makes sense

Aug 12, 2008 | Microsoft Excel for PC

Yes...no....yes....and yes. And if that sounds like a funny response let me explain. First of all you can write a formula for a specific cell (or cells or interrelated cells where you menus would display). It takes a while and if you are new to the syntax it could take a couple hours even (let's assume you are not a math major). Using Access, for something this apparently simple, I would not suggest (another learning curve but admittedly a reasonably easy one). But, this is the second yes, the easiest way to do this would be to simply insert a "comment". When you hold the cursor over the cell...your data...i.e. menu...will pop up. And yes...(last yes) you could have Sunday thru Monday across the top and Breakfast, lunch and dinner in the right hand column. Now this assumes what you have said is what your are trying to do...effectively meal planning...and you are not trying to plug in the inventory in the fridge to develop a shopping list.

Lastly...yes I could write the formula....but not knowing what you do (and figuring if you are going to use Excel at all you really do need to learn how to do it) I would be wasting a bit of time. Hope this helps...Tango.

Lastly...yes I could write the formula....but not knowing what you do (and figuring if you are going to use Excel at all you really do need to learn how to do it) I would be wasting a bit of time. Hope this helps...Tango.

Feb 04, 2008 | Microsoft Excel for PC

at first select the 1st page data and select data-subtotal from the upper menu list.

then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

Dec 04, 2007 | Microsoft Excel for PC

Dear Madiha35,

I would recommend the use of the Table Function in Excel.

Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.

Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.

Step 1: Enter your data into the worksheet.

Step 2: Create Table

Highlight the relevant data

On the insert tab, click on Table

Step 3: Verify Table range is correct, Click OK

Step 4: Select the cell you where you wish to Sum Data.

Click on Autosum.

Step 5: To Insert new data

Click on the sum row in the table, (Not the entire worksheet row)

Right click, Insert, Insert Table rows from above

Step 6: Enter new data in row

Step 7: Data is automatically calculated in formula.

Oct 22, 2007 | Business & Productivity Software

May 16, 2014 | Microsoft Office Excel 2003 for PC

66 people viewed this question

Usually answered in minutes!

×