Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula Help
Hi there,
I work in the mobile industry running campaigns and so forth. We received the sms entry report in a excel spreadsheet. What I need to do is find the region of entrants. The Entry Data report has the date, Cell number and text which was entered across columns. What I did was, I created a table of Cities of South Africa and in which province they are in. I need to match the name of the city found in the entry text to the nam of the city in the table that I have created and the result should be the province. Can this be done ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |