Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007
I would like to know 2 things.
Firstly, how do I create a drop down list. Secondly, how can I format a cell to recognise a word on the spreadsheeet and then calculate the number on the same line. I would like it to consolidate several figures and then give me at total, but it will need to recognise the word first. Cheers.... MickM |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007
In answer to your first question, select the cell you want to have a
drop down in and click on Data | Validation then under the Allow section you can choose List, and from there you can specify where your list occurs. For your second question you can use the MATCH function to get Excel to recognise a word, but you can also use VLOOKUP, SEARCH, FIND etc., so you will need to look in Excel Help to see which of these are appropriate in your case. Hope this helps. Pete On May 4, 10:41*am, Mick wrote: I would like to know 2 things. Firstly, how do I create a drop down list. Secondly, how can I format a cell to recognise a word on the spreadsheeet and then calculate the number on the same line. I would like it to consolidate several figures and then give me at total, but it will need to recognise the word first. Cheers.... MickM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting a chart from Excel 2007 to Word 2007 trouble | Charts and Charting in Excel | |||
Paste EXCEL 2007 sheet into WORD 2007 - objects move around | Excel Discussion (Misc queries) | |||
How can I add the OneNote 2007 icon to the ribbon in Excel 2007? | Excel Discussion (Misc queries) | |||
Chart Selection - Excel 2007 copy to Powerpoint 2007 | Charts and Charting in Excel | |||
how to email excel 2007 worksheet with outlook 2007 | Excel Worksheet Functions |