I have a database of 5,500 surnames and associated data in excel . It is always a task to quickly jump to each entry using the "find" function - typing in the...

i want to change number formatting from 100,000 to 1,00,000.

I have a spreadsheet with 3 columns - I want to know the number of times col A = texta, and col b = textb and col c = text c. how do I do this in excel?

So, here is the basic problem - I have one spreadsheet that has 100's of codes, and information below each code. I have another spreadsheet that’s called a...

how to add 3/4 as a fraction like (alt 171) ½ (alt 172) ¼

Hi All I have a formula in Col B =if(G2"99999","StaffType1","StaffType2"),"") Col G has the staff employee numbers in it which if they are a 5 digit number...

I need help with a formula... I have two columns of data and I need to figure out a way to have Excel figure out the third column. The data is being...

I'm using the 2007 version of Excel. I have a worksheet with 13,000 lines of data. Column A is titled ITEM and column I is titled PRICE. I need to find...

Is there a non-macro way to clear a cell's contents automatically when the spreadsheet is saved? This is one of several un-locked cells in my spreadsheet...

I have a workbook that has about 2 worksheets in it. I need to pull all the data from each column, one column at a time, into a "master" worksheet. I...

Hello, I'm attempting to creating a tabbed delimited file from excel that is going to be used for entering sale orders in an Oracle based platform. The...

hello, for sure again this is another count of appreciation. i have this very good macro that works for sheet1 only. What is the syntax to modify this nice...

I have one main workbook with a whole lot of onfo in it and when i open the otehr workbooks then they must gather certain information from the main workbook....

Hi I have to open multiple sheets of Excel at one time, but I want Excel to open new instance to Excel everytime. Currently sheets overlap eachother and I...

I want a symbol or color to appear when I have the following words entered into a cell (failed, pass, pending and offer made). I'm thinking I need an IF...

I'd like to be able to save a copy of a document onto my local drive everytime I change the original on our server. Is there a macro I can use to save it...

I have a list of dates and I want a function that will return the latest date in the list. Is such a thing possible?

Hi, I use Advance Filter to get unique reference in a table by output it to A10: A16 : A B 10 XB12 =VLOOKUP...

I want to change a work sheet and it is proctected but i have forgotten the password so what can i do

Hi, i am just starting up a small business and was wondering if anyone could guide me the correct way of having control of the suppliers and their payment...