| Thread | Last Post | Replies |
|
| How can I change default row numbers in Excel ? | 27 Aug 2006 18:52 GMT | 4 |
I wanted to change/modify the default row numbers in Excel but was unable to do it.Actually I have inserted logo which covers row 1 to 8 and then my actual data starts.But what I want is the actual row which is showing row no.9 shoudl be as row no.1 .Can anybody give a solution ...
|
| INDEX function multiple columns & rows | 27 Aug 2006 17:41 GMT | 2 |
I am trying to put together a formula that will take the column value from one cell and the row value from another cell and go to this table and enter the number that corresponds with where the two values meet. Keep getting #VALUE! error when I use the index function
|
| AutoSelect? in Drop Down List Box | 27 Aug 2006 16:31 GMT | 1 |
I am trying to create an invoice template and added a drop down list box in the description field to provide valid available product description to select from to avoid typing. Problem that I am having is that this only allows me to select
|
| Count occurences in array with condition | 27 Aug 2006 16:22 GMT | 2 |
Experts! See if you can help Column I, range I200:I800 Column J, range J200:J800 I'm trying to count the number of occurences when number in column J is less
|
| multiple condition lookup and match cell format | 27 Aug 2006 15:56 GMT | 3 |
Sheet 1: A 35 cell column, each with user intials "XXX", each cell is formatted with font and pattern choices. Sheet 2: Cells A1:M15. If the contents of a cell matches one of the cells in Sheet 1, match the contents and the format of that cell.
|
| How can I track numbered inventory? | 27 Aug 2006 12:32 GMT | 6 |
I cannot find a formula to give me a figure for exact # in a numbered inventory. For example: My items are numbered 800 to 819 if I just subtract it gives me an answer of 19 when I actually have 20 items. I need a formula that is inclusive. I tried subtracting with +1 but ...
|
| Help with function on LOOKUP with Text | 27 Aug 2006 12:25 GMT | 2 |
I'm trying to run a few simple functions, but I can't seem to find any information on what I'm doing wrong. 1.) Based on a range of inputed data (i.e., <5, >80) in cell BN171, cell BO171 displays the text "GO" or "STOP". This repeats itself down the column,
|
| condition formating | 27 Aug 2006 11:09 GMT | 2 |
I have more than 50 columns, how I can make each column condition is column dependent ? instead do column by column. I try use the paste special , it doesn't work, it just copy all formula over from the first column.
|
| Crazy Question here | 27 Aug 2006 08:31 GMT | 3 |
I want to give a visual demonstration to those who are going to be joining our team - of how to use Excel to do our job. I was thinking Power Point could some how record the use of Excel but I couldn't find any way of doing this WITH Excel.
|
| Formula to open an Autoshape | 27 Aug 2006 07:03 GMT | 3 |
Hi guys...Is there a way I can open up a textbox/Autoshape using a formula? I want the cells to check for a condition and if it is satisfied I want to print a value in a textbox or autoshape. I really appreciate your help!
|
| copying info from one cell to another, changing the format, but leaving the number | 27 Aug 2006 06:13 GMT | 1 |
I would like to transfer a number from one cell to another... problem is that after I do calculations in one format, I need the number to perform another calculation in another format... for example, I calculate time to get my total time (in minutes), lets say the number is 231 ...
|
| Weight tracking formula? | 27 Aug 2006 04:07 GMT | 2 |
I am attempting to keep track of my weight loss/gain and don't know how to write the formula so that I can tally each week the total loss/gain.
|
| Change Cell background color by selection | 27 Aug 2006 02:13 GMT | 1 |
Excel 2003 I have a table of data, and I would like to have a section of it highlighted with a different background color when the user selects the first cell in the row (selecting this cell also drives a couple of other functions as well
|
| Counting cells that don't contain certain text | 26 Aug 2006 23:39 GMT | 4 |
Is there a quick and easy way of counting the number of cells that don't contain certain text strings For example Column A
|
| How do I choose first value greater than 0? | 26 Aug 2006 22:18 GMT | 2 |
I have a worksheet with data by month in columns. I want to look through the data consecutively and find the first value greater than 0 in each row. I can do this with an imbedded if statement, but I did not know until
|