Summary: If I have a formula in A1 that reads: =sum(a2:a5000) to get the sum of up to 5000 rows. Is it possible to have that value remains as 5000 after I ins...
Summary: Assuming your data is already sorted so that the duplicates follow one another as in your example, try this code: What it does is check each item in c...
Summary: Hello, how to set the type (text, number, date,..) of column in EXCEL with VBA? (not manually through Ctrl+1 -> Format of Cells ->...) Thanks for your...
Summary: Hi, I'd like to minimize and maximize rows in excel. Note: I don't want to hide them, but I'd like to add the feature that comes up the left portio...
Summary: Hi, When you ask "What version of Excel" I presume you mean more than just the "Excel 2003" that I mentioned already? When I do "Help->About" I get "M...
Summary: Perhaps it is different for Excel 2002 but in Excel 97 you are limited to 256 columns and 255 sheets per workbook. So the maximun number of columns in...
Summary: I want to sample a cell in Excel and if it is empty, I want to delete that row. I can delete a row using the row number but can't do it using a variab...
Summary: Hi Guys, I know this is simple, but I'm very new to the MS office environment. Does someone know what I would do to add duplicate rows in excel based ...
Summary: I am trying to copy a spreadsheet created by a Excel genius who is no longer around to help me. Basically it is a utilization spreadsheet that tracks ...
Summary: I don't know if this is a one-off but if so you could do it manually. Highlight the column, change the cell to Number and set the number of of decimal...
Summary: Grok, I think that maybe you don't understand what Tony is wanting to accomplish. Your formula works exactly the same as =SUM(A76:A97) (Offset 75 row...
Summary: Tom, I think you have the idea but I'm confused on what the actual pieces of your formula mean. =SUM(OFFSET('Chip Data--Alg 1'!$L$1,9+((ROW()-1)*5),0,...
Summary: On worksheet 1 - I have a 2 columns and several rows of data. Column A has product names that are repeated. On worksheet 2 I want Cell A3 to show a l...
Summary: If you really trying to simply delete every other row in a range, try this "generic" method: 1 - In a blank column in your spreadsheet, enter A in the...
Summary: I have created an Excel query in Office 2007 to return a specific set of values from within a named range in my spreadsheet (for example, the 6PM temp...
Summary: Based on the examples you gave, I am going to assume that you are pasting the formula 2 columns to the right of the original. To get the results you w...
Summary: Hi, You haven't said what values are in column B, but as you are using COUNT() which counts the number of cells containing a number (Excel help states...
Summary: Hi all, having a problem trying to merge rows in a client database due to duplications. What I need to do is merge all values into one row. Format is ...
Summary: I am new to Excel macro and I need your help. I have the following input data in Sheet 1: a1 b1 (a1 in cell A1, b1 in B2) a2 b2 (a2 in cell A2, b2 i...
Summary: Hi All, I have a number of cells in a column with the word "Minute" , "Hour" , "Day" or "Week" and want to check the value of the cell is either of th...
Summary: re: I doubt if I can determine the version of XL In any Excel spreadsheet, click on Help...About Microsoft Office Excel to get the version. re: wherea...
Summary: Thanks! What I really need is a way to count the highest number of 1s in a row, in a table of 1s and 0s. So I guess I can go with =longest($A$1:$A$8,1...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
