How to ignore hidden columns in an "Average" formula?
If an "average" formula includes multiple columns, and those columns change
each month by hiding old months (at end) and adding new months (at beginning)
what can be done, by macro or in formula) to ignore the hidden columns?
Try this if you can use 101 in your Excel version
Regards Ron de Bruin
"DotK" <DotK@discussions.microsoft.com> wrote in message news:D6F36A22-BDE4-4836-98AE-028A616A9300@microsoft.com...
> If an "average" formula includes multiple columns, and thos...Using angled column headings and borders
I'm trying to use angled column headings and borders so I can fit many
columns across the page. I've tried following an article called "Using angled
text and borders in Excel", but my results aren't very good--I'm having
trouble placing the angled borders and angled text properly. My borders don't
bend at the same angle, I guess because the columns are different widths.
Also, the angled border sometimes runs through the angled column head. Can
If you angle the text (Format>Cell>Alignmnet and then use the dial to ge...Excel: keeping rows together when ordering order of left column
in my spreadsheet I want to order the left hand column (in ascending numbers)
but when I do I want the rows to move with cells too, keeping the items of
data in the rows with the original items of data in the left hand cells when
they move place
Select the data say A1:J10 and then from menu Data>Sort>
--If your data has headers then select 'My data range has' headers ..
--Select 'Sortby'..and hit OK
> in my spreadsheet I want to order the left hand column (in ascending numbers)
> but when I do I want...Finding Duplicated Text within Columns
I'd be grateful if anyone could help me with the following:
I have 2 columns, both contain a number of items, some the same, some not; eg:
Column A: Column B:
Row 1: apple pear orange apple orange
Row 2: orange banana banana orange
Row 3: peach banana melon grape apple orange
I need to compare the columns and find which rows are NOT exactly the same
and, preferably, to identify the differences.
For instance, in the above example, I would ignore Row 2 as the cells
contain the same items (albeit in a different order), but I w...Dual boot in reverse
I have dual boot system:
driveC --> WinXP
Now, I do not need WinXP anymore.
I want to have only Vista and combine C & D into one, single partition.
How to do that without reinstalling Vista?
Your thoughts appreciated,
On Sun, 17 Jan 2010 15:00:12 -0500, "Claire" <replyto@fra> wrote:
> I have dual boot system:
>driveC --> WinXP
>Now, I do not need WinXP anymore.
>I want to have only Vista and combine C & D into one, single partition.
&...sorting multiple columns
I have multiple addresses on a work sheet. I need to have all the same zip
code # together. How do I sort them by zip code so right name and address
ends up with right zip code
Highlight the range you want to sort before starting it.
"arbe" <email@example.com> wrote in message
>I have multiple addresses on a work sheet. I need to have all the same zip
> code # together. How do I sort them by zip code so right name and address
> ends up with right zip code
Pre-se...Finding the row number of first row in a selected range
I'm attepting to find the row number of the first row in a user selected
I'm looping throgh the rows to perform a comparison and can establish the
total number of row using
Dim Lrows as integer
Lrows = Selection.Rows.Count
How do I extract the row number of the first row, please.
Thanks in advance
Eamon Wall wrote:
> I'm attepting to find the row number of the first row in a user selected
> I'm looping throgh the rows to perform a comparison and can establish the
> total number of row using
&...Copying selected columns from 1 chart to another.
This was previously asked in programming but the original question was
missleading the answers so:
From the start:
My chart has names in A7:A78, skills in D1:AA1.
Using RAND() and indexing a separate vertical list of the skills I can
randomly generate 4 from the list. These are placed in C160:F160 with the
list of names copied to A161:A232.
What I want to do is find each randomly generated skill (C160:F160) in
D1:AA1 then copy the corresponding data from below it (*7:*78) into C161:C232
for the 1st skill, D161:D232 for the 2nd and so on for all 4.
1st gener...Deleting/removing unused rows in a worksheet
Excel 2007 all MS updates
Is it possible to delete rows without ANY data automatically? Currently, I
have a 2000+ row spreadsheet that has 250+ blank rows. Instead of doing this
manually, how can the removal or deletion (squishing!) of the blank rows be
done? For example, say I have a spreadsheet with data in rows 1, 2,4,6,8 and
12. All I really need are THESE rows with data. I want to squish,
eliminate, delete the rows in 3,5,7,9,10,11.
How can I do this by 'highlighting' or whatever the entire set (rows 1-12
above) and then performing an "delete empty row"...Column headings switched to numbers
Bit Frustrated and know the answer is simple but can't seem to find i
I have one spreadsheet where the column headings are numbers rathe
than letters and all referenced appear to be distinct to the Row an
Column R1C5 etc. In some cases formulas are generated with what appear
to be relative row/column numbers. I would like to get this spreadshee
back to the Normal row and column headings so the functions work as
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly fro...Purchase Orders/Transfers
When we print a PO or an Interstore Transfer, extended costs and total of the
shipment, etc. do not print on the form. Is there a way to set these up so
they do print?
I've a table like this:
ID - PartNo
I pass a query to access (through ASP.Net) like this:
Where PartNo In
The result is:
but I expect this order:
How can I customize order query?
Something like this imaginary query:
Select * From tbl Where PartNo In ('d','a','c') Order By
Where PartNo In
order by PartNo='...How do I change column (A) to say First Name?
I want to rename the column can that be done. Like I do in works. Column (A)
I want to change to First Name. and then change B and so on. Can that be
done in excel 2000 . Thanks.
No it can't be done. Best you can do is put the heading in row 1, and
suppress row and column headings (Tools>Options>View and uncheck the Row and
Column headers box.
(remove nothere from the email address if mailing direct)
"nort99" <firstname.lastname@example.org> wrote in message
> I want to rename the c...<Enter> to go to column A?
I have a spreadsheet in which the <Enter> key causes the cursor to
move one column to the right. But, when in the last column for this
sheet I'd like the <Enter> key to cause the cursor to drop down one
row and go to column A. I know this can be done with a macro, but can
is there a way that this can be done solely with the <Enter> key?
Not solely with the <enter> key but you can use the Tab key to move to the right
as you enter data.
When you get to last column hit <enter> key to go back to start column one row
Note: <enter> ke...Manufacture Order Create Date
I am looking at WO010032. There are various date fields, but none for
"create date", as in when the MO was created. Does this field lie in any
Thanks in advance.
Sr. Microsoft Dynamics GP Applications Consultant
Certified Microsoft Dynamics GP Specialist
The MOP_Order_Activity table (MOP10213) contains a line for each event in the
MO's life. Pull Line sequence number 1.000 (the first event) and this will
be the creation date.
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and...Open Order Errors
I get the error message "An error was encountered while attempting retrieve
account credit information" every time I open an order
"No sales orders can be added at this time....."
This has only just started happening and I have rest all my defaults in IE.
I have the same access as another user who does not receive this error
HOW CAN I REVERSE TEXT AND PICTURES ON PUBLISHER TO PRINT ONTO T.SHIRTS
spike <email@example.com> was very recently heard to
> HOW CAN I REVERSE TEXT AND PICTURES ON PUBLISHER TO PRINT ONTO
YES. PLEASE READ REPLY TO YOUR FIRST POST.
Please do not talk in all caps. It is considered shouting and makes your
post difficult to read and is rude.
Your first message ("how do i reversie pictures and text for printing to
t.shirts") is directly below this one and has been answered by yours truly.
Ed Bennett - MVP Microsoft Publisher
...What is an automatic way to delete all rows of a certain kind
Is there a way to do this automatically?
I want to change (a) below to (b) below further (i.e. just all those
rows in between the data - pretty simple)
I have a lot of data, lets assume.
27 4:11 5:44 1:12 5:08 8:38 10:12
28 4:12 5:45 1:12 5:08 8:38 10:12
29 4:12 5:45 1:12 5:08 8:38 10:12
30 4:13 5:46 1:12 5:08 8:38 10:12
Date Fajr Sunrise Dhuhr Asr Maghrib Isha
1 4:13 5:46 1:13 5:09 8:38 10:12
2 4:14 5:47 1:13 5:09 8:38 10:11
3 4:15 5:47 1:13 5:09 8:38 10:11
4 4:16 5:48 1:13 5:09 8:37 10:11
5 4:16 5:48 1:13 5:09 8:37 10:10
6 4:17 5:49 1:13 5:09...POP
Hello all, We have an issue where we have change all our POP numbers to
000000000000010000 and what I want is on the Purchase order report for only
the 10000 to show up.. I have tried shrinking the the Po Number field down
and it still shows the entire 000000000000010000. I beleive I also have set
up the security correct but still shows the same.. TIA
Using Office 2007 and windows XP. The back slash has become "multiply" and
the star has become "divide". In other words, these two symbols are
reversed. Have no idea how this happened. How can it be reversed back to
Please give an example of formula, values of input cells and result of
Microsoft MVP - Excel
"RENEE" <RENEE@discussions.microsoft.com> wrote in message
> Using Office 2007 and windows XP. The back slas...update next row
I need to update a field in a table I use for grooming data.
....and it would loop through all rows and stop at last row
How do I accomplish that with an UPDATE query?
After update, data gets exported then deleted.
On Wed, 2 Dec 2009 21:47:15 -0500, "shank" <firstname.lastname@example.org> wrote:
>I need to update a field in a table I use for grooming data.
>...and it would loop through all rows and stop at...LOOKUP a column from another worksheet
Help please i want to show a column from a worksheet based on a TRUE/FALSE
Condition . That is if the value in row2 is TRUE show the column ( im wanting
to show this data on a different worksheet within the same workbook) does
this make sense ??
Put this say in sheet1 A1
It reads in cell A1 from sheet2 if the statement "TRUE" is in cell
B1 of sheet2
If B1 reads "FALSE" it will stay blank ("")
> Help please i want to show a column from a worksheet based on a TRUE/FALS...SOP Order Fulfillment Detail Report
This report is using Sales Serial/Lot Work and History Temp which doesn't
include the Manufacturing and Expiry Dates.
I tried to include the Sales Serial/Lot Work and History table but it seems
that there is no option for me to do it in Report Table Relationship.
...SUm function and adding rows
Is there a way to get the SUM function to increase the range if a row is
added right above the previous SUM range. FOr example to go from SUM(C3, C22)
to SUM (C3, C23) when I insert a row directly above row 24 - wher the SUM
You could use a formula like this in C23:
> Is there a way to get the SUM function to increase the range if a row is
> added right above the previous SUM range. FOr example to go from SUM(C3, C22)
> to SUM (C3, C23) when I insert a row directly above row 24 - wher the SUM
>...Possible to reverse a row of entries?
Is there a command or format command that will let me take a row of entries
and reverse them? In other words if I have rows #1 through #10 top to bottom,
I now want them to go #10 to #1 top to bottom.
in B1 enter
and copy down for ten rows
> Is there a command or format command that will let me take a row of
> entries and reverse them? In other words if I have rows #1 through
> #10 top to bottom, I now want them to go #10 to #1 top to bottom.