In the example below I am trying to determine the rows that contain duplicate account numbers. I am thinking that if I could do an IF/AND function I could get...

How can I copy "Page Setup" Settings from a Spreadsheet on one Workbook to a Spreadsheet in another Workbook. (I am just starting to use Excel XP. I use to...

Hi, I have a basic queastion, but I can't find any given limitations written anywhere. I have managed to group, in two levels, columns from "H" to column "DA"....

I can double click and get the words but when I move off the cell, it returns to pound marks,

I have auto save in Excel set to every 5 minutes, but it is not auto saving the data. What should I do to fix it? Jennifer

I have a spreadsheet that I created a while ago, and have just gone back into it. I have password protected the spreadsheet before I last left it, and now...

I've got a macro that does a bunch of things and at the end puts a number value in a cell. I would like to write out that value to be displayed in a...

hello everyone, i was wondering if there is a way to change the color of text in the active cell only! i know that the background color can be changed in...

I have a listbox which I am listing cells a1:a1000 on a worksheet called "homes". I would like the ability to have the user highlight the item in the list box...

I have an workbook that just wont email thru excel. As far as I can tell there are no special formatiing, and its a small workbook. others files work...

Hallo! I´me a new member in your forum, can somebody help me to solve this problem in excel please: I need to make combinations with a makro or a funktion in...

I have a simple table where data is gathered from another worksheet (lets call it WS2), the formulas look something like: Col A Col B Col C ...

Can i use an if statement to use a picture as a result? -- comotoman ------------------------------------------------------------------------ comotoman's...

I have data I need to analyze with a Pivot Table, but I can't because there are multiple columns. I have time series data, where the first column has the item...

How do I open an Excel document using Microsoft Works spreadsheet. I do not have Microsoft Excel.

I am trying to set up a formula to calculate my over-time. I want to set up if number is greater than 9, 9 goes to regular time and balance to overtime and if...

When i have formulas with there criteria not fullfilled, i get the "#N/A". How do i get that to go...

Hi everyone, My problem is with the COUNTA funciton. I have a formula, "=IF(COUNTA(K4:Q4)0,1,0)", set up so that if at least one cell has a letter/value,...

I have a spreadsheet that needs to be sorted. However, some of the rows need to be grouped and sorted with its heading row. How can I do this? Renee

numbers ranging from 1-56, 5 places, and no 2 numbers the same. then 1-56, 1...