Functions

find
I am trying to set up a worksheet at work that lists case numbers in the following format ab12345 how do i do a search for a specific case and I want to search the entire workbook. ... 24 Mar 2010 23:54

Segrigation of different datas from one colum
Hi , I am trying to segrigate and pull data from one colum to different colums. For this I want to created a macro . Also I want this data to be pulled from a word document and to be pasted on an Excel template.Is it possible ??then How can we do it . ... 24 Mar 2010 19:22

Last cell with data in a range
I enter weekly data into a spreadsheet with a summary page at the front. After every week, when new data is entered, I want the formula at the front to use the cell with the new data instead of me having to change the existing formula. For example, my data looks like this: A B C 276 300 ... 26 Mar 2010 12:01

Excell Spreedsheets
I have thee monitors running at one time. How can I work on two Excell spreadsheets at a time and be able to run one on one monitor and the second on another monitors at the same time? ... 24 Mar 2010 19:22

Excel data from spreadsheet to database
Can anyone please direct me to an article that has instructions on how to gather data from an Excel 2003 spreadsheet into a separate database? Thank you, Ricki ... 25 Mar 2010 15:02

group/ungroup protected sheets?
Is it possible to allow users to group & ungroup rows in a protected sheet? ... 25 Mar 2010 15:02

Row Height Adds Blank Space at End of Text
Hi, We have a spreadsheet where the row height is automatically expanded to add extra, blank space at the end of the cells. We manually adjust the row height, save, close, and when we re-open, the space is back. There are no extraneous returns in the cells. Anyone know how to fix this? Auto Fit does not w... 24 Mar 2010 15:53

Select 'Sort By' column by simply typing heading letter
Hello, In the next version of MS Excel, please restore the ability to define Sort By columns by simply typing the Column heading letter as was the case in Word 2003. When Excel 2007 came out, I was astonished to discover that capability was no longer available. For example, suppose I want to sort a large... 24 Mar 2010 17:03

Circular Reference Warning ???
Hi I receive a this message 'Circular Reference Warning'...One or more formulas cantian circula reference and may not calculate correctly. How is this happened? I checked all the formulas I think they're okay. Am I missing something? How I do fix it? and how do I clear this message Circular Reference wa... 24 Mar 2010 18:11

mark up
need to mark up 16800 items by 15% column e is my net and need column f with new prices ... 24 Mar 2010 17:03