How do I count the number of cells
I have several dozens columns and 52 rows containing Data.
All the columns are labled Odd or Even
In the final (right most) Column I want to count the number of times that
that coulmn has data in it
The last row belows shows what the answer should be
Odd Even Odd Even Odd Even Odd
5 1 2 ????? ?????
1 7 6 3 ????? ?????
5 1 2 ????? ?????
1 2 9 3 1 3
- will count the number of non blank cells.
In the brackets place the range name (for example A1:A2).
Please hit Yes if my comments have helped.
&...Dynamic unlock a cell (under condition)
Hello guys, lets see if anyone could help me out on how to do this:
I have a sheet protected with a password, the reason of this (you know)
is that there are some cells that are locked (to not see their formulas
or 'cause I don't want them to be changed under any circustances).
This is working fine, but now I have the need of some cells (two ranges
actually, these are E7:E56 & N7:N56) that they come locked by default
but under certain conditions I would need them to get unlocked.
Taking an E7 as example, let's say that depending on what we have in B7
this E7 will chang...Customer Returns
I'd like to know if there someone has written a RMS report that shows the
customer account number, customer's name (last, first), and other customer
statistics that INCLUDE pieces purchased and pieces returned.
Or, if someone with more knowledge of SQL would care to share their coding
expertise to accomplish the same, it would be appreciated.
...Comments in Cells
Is there a way to show the comments against a cell when printing a worksheet
You can print the comments as they display on the worksheet, or at the
end of the worksheet. There are instructions in Excel's Help, and here:
> Is there a way to show the comments against a cell when printing a worksheet
Excel FAQ, Tips & Book List
"Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
news:407D1E25.407...Convert VLOOKUP to absolute cell reference
My spreadsheet has a VLOOKUP through 44,000 rows that only needed to be
performed once. The relevant data is in the VLOOKUP cells as I want them and
the lookup values will never change. As long as I keep the other worksheet
intact, can I convert the VLOOKUP formulas to absolute references? My
spreadsheet is running very slow with the VLOOKUP in place, so I'm trying to
speed things up. Would this idea work?
You can try to convert all the formulas as values by using copy and paste
also you can try to go to options calculation and change the options to
manu...Return-Path: <> from Postmater
I got Exchange 2003 SP1 on Windows 2003 in Native Mode and when I receive
bad mail the response is made from firstname.lastname@example.org but the
return-path field is blank. With some anti-spam filter this Email is Junk.
Anybody know how to specifeid a return-path to the NDR mail?
On Fri, 4 Nov 2005 12:48:04 -0800, "Sebas"
>I got Exchange 2003 SP1 on Windows 2003 in Native Mode and when I receive
>bad mail the response is made from email@example.com...Remove Cell Auto-Format (General) on Paste / Replace
Good morning all,
Just curious if this is able to be done. I have a series o
spreadsheets, all of them do different things, but the common factor i
that I paste claim numbers into them. The problem is, Excel seems t
think our claim numbers are dates. (Example. 2146/04 or 04/262
(different formats for different sections). Now, I have formatted AL
cells on these spreadsheets as text. (Ctrl-A, Format-Cells-Text
However, when pasting, Excel overrides whatever you've got, and choose
it's own way to paste data.
The other problem is with Find-Replace or Find-Replace All. A lot o
the time, ...Format cells unavailable
I am assisting a customer running Word 2000 on a Windows
2000 system. He has a spread sheet that will not allow him
to do a format > cells on the header row and a few rows
below. We can select the colum and this option works but
nothing happens when using this option for an individual
cell. I don't think these items are protected, is there
any way I can be sure? I tried selecting all of the
columns and unlocked the cells and this did not help. Can
anyone think of any reason why format cells would not be
available on this sheet?
Tools, Protection. If the sheet's ...Use tiltle in a cell
Is there a way to use the title of the spreadsheet as a cell value?
I asked this before in another topic, but there was no reply.
My sheet get's it's title from a database and is variable.
So if i can use the title i can strip several characters from the
title and use this.
So I want to retrieve the title of the spreadsheet and use this in a
The name of a worksheet can be extracted to a cell with:
Bernard V Liengme
remove caps from em...Report for Returns
Anyone know a why to report on frequency of customer returns -- so we can see
if any customers are making habit of this?
Thanks and regards,
Try running a detailed sales report filtered to only negative sales
"hitman" <firstname.lastname@example.org> wrote in message
> Anyone know a why to report on frequency of customer returns -- so we can
> if any customers are making habit of this?
> Thanks and regards,
...displaying a comment only when the cell is selected
I'd like to insert a comment in a certain cell, so that when that cell is
selected by a user, the comment is then displayed. I know this must be
possible, but I haven't been able to figure it out....
I can show or hide comments in various combinations, but can't find a way to
hide the comment UNTIL the cell is selected, and then display it. How do I
do this please?!
Use Data Validation.
Select the cell
Select the Input message tab
Type in your message
The message will only be displayed when that cell is selected. (no mouse
ov...Advice Needed On Change To Exchange Server Based Email
My web hoster offers Exchange email and I am thinking of changing my main
business email address from ordinary POP3 to Exchange hosted so that I can
access all my email messages, contacts, etc from any location.
My hosters tech support people can't seem to explain to me clearly about
what would be involved in doing this but from reading the FAQs on their web
site I believe that I can download some software from their web site that
will create another profile within my Outlook 2007 and that emails to/from my
main business email address will then be received in this profile.
...Move cell info and info in range of cells on new entry
I would like to enter info into exsiting cell and when I hit enter the
existing info would move down one row.
B C D E
5 Enter new info her existing info moves down
Thanks for the help.
You could use a worksheet_change event macro within your sheet module to do
this when you enter a value into the last column of the existing row.
Microsoft MVP Excel
"abc" <email@example.com> wrote in message
news:8378874C-D0D0-4E73-98F6-F48E61B60898@microsoft.com......Data Tables on Charts
I have 2 files. The first has the source data while the
second has the graph that's linked to the data that is in
the first. The chart has the option "Show data table" on.
When both files are open, the data in the data table is
formatted correctly with commas and the correct number of
decimal places (ie 1,250.2). However, when I close the
source data (or just open the chart file alone) the data
table has the values without commas or decimals (ie
How do I get the data table of the chart file to retain
the formatting without having to open the source??
I am ...Site for SOP Returns
Is it possible to have a different default Site ID for Returns than Standard
Yes. You must make sure to change the site when performing a Return
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
"Everton Raymond" wrote:
> Is it possible to have a different default Site ID for Returns than Standard
Sorry, I did not see the word "default" in your post until after I r...Merge/consolidate text cells based on unique keys ?
I hope someone can help me out.
I have an Excel worksheet with 2 columns: 'Client #' and 'Invoice #'.
Every time the accounting dept. generates an invoice, a new row is
added in this worksheet.
Obviously this is chronological not per Client #.
But for the sake of simplicity, let's assume the worksheet is already
sorted by Client #, like so:
Client # Invoice #
My goal is to achieve...Query regarding A,B,C char. width values returned in 16-bit and 32-bit OS
I am trying to retrieve individual character widths of a string
(from a TrueType font) and I tried using GetCharWidth (which weirdly
works for TrueType fonts too tho' MSDN says otherwise) and/or
GetCharABCWidths to retrieve the A,B and C spacings. Please
note that I have selected the TrueType font (hFont) into the Device
I used GetCharABCWidths. Problem is this: GetCharABCWidths returns
correct A,B and C widths in Win 98 and incorrect (much lesser A,B and
C widths such that the characters OVERLAP) in other 32-bit OS (NT,
The effect is seen across all TrueType fonts, th...Export Table Records to txt file
Hi all, I have Table "T_Data" in my database. In "T_Data" I have
220000 records. I need to export them into txt files. I need some
kind of macro which should export chunk of 60000 records into one txt
file and save that file in folder called "Data" on "C:\" drive. Macro
should also put numbers at the end of each txt file name. Like (See
I'll be very greatful if any friend can help me on this as I am
struggling on this.
...Returning the Beginning of the week
Returning the beginning of the week.
e.g. if the date == 02/03/04 (Friday 2nd March 2004)
the beginning week for that date == 01/03/04 (Thursday 1st March 2004)
Hows does one go about achieving this?
Rizitsu's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15840
View this thread: http://www.excelforum.com/showthread.php?threadid=314968
This formula will take a date in cell A1 and give the start of the wee
* assumes that monday is the start of the week, so i...Linking Dialog box content with cells in "regular" sheet
How to link data in Edit box (from Dialog caption) with exact cells in
"regulal" Sheets? Or is there another way to link exact content from Dialog
sheet to normal sheet? For example, if I have number 200 in Dialog, I need
that exact number 200 on another ("regular") sheet to preform calculations
with it. thnx
Capability of the system to automatically change the status of the PO to
change order, and add line items that have been returned.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.ms...Replace empty cell with cell on right
I wish I could write macros!!
I have a spreadsheet of names and addresses (name, add1, add2, add3, add4,
add5). I want to mailmerge them but some add2s are empty, because whoever
typed the data in put the next line in add3, and some add3s are empty
because they used add4, and some add4s are empty etc etc This means that the
mailmerge (into Publisher - yuk!) puts blank lines into the address.
I would like (please!) a macro that, if I select the range add1-add5, will
squash the details to the left - so all of the empty cells are on the right!
Good news - you don...Copy Cells
I have a spreadsheet which has lots of calls logged on it. Each call is
logged by a person. I have a tab for each person.
What i need to do is each persons tab needs to pick up the information
for that person (pick it out of the main sheet which has everyones call
So any cell in column 'A' with the name 'Joes Bloggs' needs to copy
accross to tab 'Joe Bloggs' along with the rest of the information on
Hope this makes sense, if you dont understand reply with a question.
Thanks in advance
Message posted from http://www.ExcelForum...view of cell contents changes to #### when cursor leaves cell, ev.
In Excel, view of cell contents shifts to ###### when cursor leaves cell,
even when auto-fit, wrap text, shrink to fit, have been tried, and even when
row and column have been enlarged to allow adequate room.
I found the earlier posts (sorry not to have scanned) and the problem was not
about size but about Number. When I selected "general" under "format cells",
the text reappeared as entered. Thank you to earlier questors!
> In Excel, view of cell contents shifts to ###### when cursor leaves cell,
> even when auto-fit, wrap text...form creating new row in table1, looking for field value in table
Please can someone help as I have been battling all week with this problem,
and haven't had a response.
I have a form which uses some data from table1 to create an entry in table2
(i know duplication is bad, but as this is a live database, and i am working
on a new section, this makes this complicated task easier), which works fine.
however, i have a third table that has the unique ID from table1 and table2
in order to show when a table1 row of data is needed in table2 via a
checkbox. This third table3 is created when elsewhere.
The problem lies with bringing in the unique ID value...