How can I get change column A to become field names and column B to file the information into the correct fields in each column?

Hi Everyone, I have a table of data and need a COUNT of the NEXT Row when various criteria is met for the Row above. I'm using the SUMPRODUCT criteria to find...

Hi, I want to have a formula in a cell that counts the number of time a certain word appears in any cell in a worksheet. i've tried using count but it...

I recently developed a unit converter that can handle complex strings and biased units using Excel. It can evaluate formulas in a "free-form" way and yet...

Greetings and thanks in advance for your time. The following scenario captures the essence of the problem: In an empty spreadsheet, if I enter "" into cell A10...

I have list of numbers (approx 350) that is five digits long. Is it possible to use a formula to extract the 1st, 3rd and 4th digits from these numbers and...

I am trying to ad onto an IF formula and I need help. I am using this formula to count the number of apartments that are vacant. Some apartments have illegal...

I been building a spreadsheet to record data and would like to interchange the rows and columns to make viewing easier (I want to make the row data become...

I have formulas in ColA. I would like to vlookup ColA if the cell is not blank. IIf the cell is blank (formula only) I would like the cell to be blank. Is it...

Is there a way to have excel to highlight each instance of a particular word in a file? Eg. I need excel to look for the word "delivered" in a worksheet...

as time values for a graph, how can I get these accepted as dates to plot data for a time series for, let's say, housing prices between 1750 and 2005?

how to format numbers stored as text or vice versa to use vlookup, match, etc.... I have a spreadsheet that I am having supplied by other people. It has part...

My old computer used Lotus Approach 9.5 and I saved files on a disk. That computer no longer works. I need to open these APR databases in my new computer...

I have a list of names in a specific worksheet using the list manager. I want to have the same list in another worksheet with out having to copy and paste...

I am reproducing a court financial statement into Excel and need to know if it is possible to create two or more spreadsheets (or tables) with varying column...

I am trying to use auto fill and when I drag the fill handle down it does not give me the Auto fill option box so I can change the options, how do I get...

Can anyone explain why there are "ghost" blank cells when a pivot table is present on a worksheet. If you have a pivot table that starts in B1 and if you...

Someone showed me how to set up graphic slider bars in a spreadsheet so you could adjust values in scenarios to solve problems , goal seek, etc. I do...

I am having the IF function evaluate a row of numbers for the last cell populated with a number greater than 0 (zero). When found it is performing...

Hey Everyone, I'm trying to get a linear regression function to work and am having a lot of difficulty. I need the function to do a linear...