Summary: I need to count a non blank cell in a column only if a certain cell in the corresponding row is blank. For example I am counting all non blank cells ...
Summary: Great! Thank you for your detailed response DerbyDad03. Before I input your data, let me expound a little further to make sure we are on the same w...
Summary: Hi, The following user defined function will return the smallest letter. Lower case are 'smaller' than upper case and blank cells and cells with a spa...
Summary: Hi, Here is some code for a macro that deletes every row in a selection, unless the row is a multiple of 300. In my test, I entered data in Cells A300...
Summary: Take it from start. U open ur master doc in word and have a copy of it. Ur file in excel, must be at 1st line "name of fields" i mean 1 row=1 field na...
Summary: It sounds like wanting to have rownumbers in the A-column, only when B-column is filled, use: =if(B2<>"";A1+1;"") (Copy it in A2 and fill down lik...
Summary: My backup PST file shows "Outlook.pst is not a Personal Folders File" when I try to add it as an Outlook Data File. SCANPST.EXE detected 2 errors and ...
Summary: Good day, i have two excel sheets, one with information in rows and each row has an id number (1,2,...,300) and the other sheet has the same structur...
Summary: If you really only have three columns of data, then you can do it with a single brute force nested IF statement. The problem is that any more than 3 c...
Summary: I have a spreadsheet which I use for a BOM. It is linked to a Master table which is stored and updated as required. I used to use a drop down list wh...
Summary: I am trying to align numbers in a column so that all of them are centered. All the numbers are automatically and correctly put into their respective c...
Summary: Hello I used the formula in another way Each row have a label in the left representing the sheet no. it summarizes as per the below formula cell A7 co...
Summary: Hi, There are various ways to go about this. I would first of all complete the Sales Person column, so that every row is complete. In A3 put the formu...
Summary: My apologies for the confusion. My data set currently has 200 or so referents. If that list was final then it would be easy. I would just use the Co...
Summary: Hi, As I pointed out the sort function works only if each entry is on its own row. Rather than retyping the entries you can bring the data onto single...
Summary: I have an issue at my company where some users are having issue with certain Outlook messages not marked as forwarded or replied to after the message...
Summary: Atomic means "no further divisible" (yes, long time ago the "atom" was believed to be the ultimate particle of matter), so an atomic value means a sin...
Summary: I have a very confounding problem that is affecting all users in a small (5 person) office I support, running XP workstations and Office XP on a NT 4 ...
Summary: Hi everyone I have a formula on each row of a column to show quantity times unit price " =sum(g6*g7)" but, if the line is not used the formula cell di...
Summary: Your information is not specific enough but MS Excel is a wonderful application. If your data is a text document that contains columns and rows then y...
Summary: I'm using MS Office Prof. Edition 2003 Excel. I have a spreadsheet "BOM" with 3 columns, Parts Number, Description, and Quantity. I would like to ge...
Summary: I'm running across the same issue as a previous poster ( http://www.computing.net/answers/of... ) in Excel 2007. Namely, that often when I click on a...
Summary: I'm not sure if this will get you exactly what you want, but it might get you started. First, some assumptions: Initial investment = 10,000 Annual int...
Summary: qmail is not working properly some time user cant able to send any mail,That time if i restart the qmail with following command ( qmailctl stop and q...
![[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
