Description:
Microsoft Office Excel newsgroup.
|
|
|
Formula to count new records in pivot table
|
| |
I have a pivot table where the columns are months and the rows are vacant staff positions. If the position needs a person in it that month it will have a one in it, if it does not need to have a person in it the value will be zero. What I need is a formula which will allow me to identify the number of new... more »
|
|
|
Autofill question
|
| |
Hi there...I need a VBA script that I can use to autofill down a column...so if row a5 had a heading of "happy" and then z5 had a heading of sad... I need that script to fill down from a5 to y5 with Happy and then from z5 fill down to the next heading with Sad... can you help??
|
|
|
How can I import a very large PDL from outlook into excel
|
| |
Hi I've got a PDL that has 2000 names on it and I need to update it. I have a list of names in excel which is the latest informaion that I need to compare with the names on the PDL. I know I can use a vlookup to do the comparison but when I try and bring in the PDL as a text file I lose all most of the... more »
|
|
|
Short listing the Data Validation List
|
| |
I have over 4000 entries as the prd code & need to enter them on a worksheet. By using DATA VALIDATION is there a feature to shortlist the list when typing letters. ( Like a LOV ( List of values in Oracle Forms )) When "C" is types only the codes starting with C will be shown
|
|
|
Error calculation
|
| |
Dear Support, I was tryting to calculate the total variance with expected result equal to 0. But we received a very strange result. We subtract Figure1 data from Figure 2 and receive variances. After this we used Sum function to calculate the total amount and see strange number see below. While if we calculated... more »
|
|
|
Hyperlink to PDF not working
|
| |
I am trying to link to a PDF file and using Ctrl K and/or =HYPERLINK opens the file for a breif second then closes down. How do I get the file to open and remain open. This one is baffling me.
|
|
|
Formula Extend in Excel 2007
|
| |
I have a fairly simple spreadsheet in Excel 2007. As data is entered into a new row, some of the formulas from the previous row automatically extend into the new row (which I want), but some do not. Why is this? Thanks, Dean
|
|
|
|
