Worksheet Functions - Page 482

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
Need help displaying odd numbered month by Greg L[_3_] I'm trying to get the odd numbered month (Jan, March, etc) and display the next tenth of that month. For example: If its the 9th of Jan, display 1/10/current...	June 30th, 2009 04:27 AM by Sheeloo	3	90
count formula by OKY Hi I am makeing a worksheet for the dispatchers ast works. This is what I did so far. TECH NAME JOB# TIME HHHC STATUS LUIS G ...	June 30th, 2009 04:05 AM by OKY	2	120
How can I group and display columns automatically? by faraz316 I have 40 columns on a worksheet and many rows, and want to set up vertical groupings i.e. group columns (A, D, G, J ....) together, and then (B, E, H, K......	June 30th, 2009 03:27 AM by Ken[_22_]	3	133
Automatically copy from Master worksheet to others by Susan S I am new to Excel, so please pardon my low level of comprehension. I have a large workbook with 4 worksheets (master, Entity A, Entity B and Entity C),...	June 30th, 2009 01:08 AM by Ashish Mathur[_2_]	5	181
Skip Rows in Fill Series and Filter to Two different sheets by Benjamin I've got a fill series of unquie entries. Col A B C D Status xx xx xx I need to copy the rows to different sheets....	June 30th, 2009 12:58 AM by Ashish Mathur[_2_]	3	133
Multiple column filtering by faraz316 Hi, I am trying to group multiple non-consecutive columns so that all columns can be hidden and each group can be displayed. I have 40 columns with...	June 29th, 2009 11:35 PM by Shane Devenshire[_3_]	2	112
SUMIF, IF ? by Steve I have this formula: =SUMIF($B116:$B124,"V",S116:S124) In Q116:Q124, I have various numbers, such as 1300, 1400, 1500. What can I add to the above formula to...	June 29th, 2009 11:23 PM by Steve	5	162
Using Advanced Filter: How do you MOVE the selected rows... by ravif I can copy the selected rows to another location, but is there a way to move the selected rows, so that the original sheet has only the unselected rows? I...	June 29th, 2009 10:25 PM by Fred Smith[_4_]	3	121
How can I get Microsoft excel to calculate increasing number again by Anna I am a small business owner and what I need is to price my inventory. Let's say my lowest cost ($0.01) will be multiplied by 20%....and my highest cost (...	June 29th, 2009 09:59 PM by NBVC[_66_]	4	125
Breaking links in Excel by brosull how do I break an excel link to another worksheet when "Break Link" work? Thanks to Shane for replying.	June 29th, 2009 09:38 PM by Shane Devenshire[_3_]	2	84
Help with SUMPRODUCT by EricB =SUMPRODUCT((crq1!$B$2:$B$10000="app")(crq1!$F$2:$F$10000="Sys")(crq1!$H$2:$H$10000="")) Column â€˜Hâ€™ contains blank cells and cell with random...	June 29th, 2009 08:29 PM by NBVC[_59_]	5	125
Sorting 2 data columns in Pivot Table by Alonso[_2_] Hi everybody I have a pivot table with 2 datas (HI and LOW) for each row I want to sort them descending on BOTH columns -when HI has the same value for 2 or...	June 29th, 2009 07:28 PM by Alonso[_2_]	2	100
unable to open protected document I created by TBryan I created a document with formulas and made it PW protected. I am now precluded to open the document to make edits. I am unable to select "unprotect" and use...	June 29th, 2009 07:07 PM by Harlan Grove[_2_]	2	156
Locking a Spreadsheet but allow inserting by Tami I have a Buyers spreadsheet that the majority of it needs to be locked/protected. The buyer can then type in the styles names, units, cost of styles they...	June 29th, 2009 07:04 PM by Tami	5	158
select max value from row of data and column containing max value by Jesse I'm using Office 2003. I have a large table and I'd like to evaluate the data and get a summary of some metrics of the data: - the name (column) with the...	June 29th, 2009 07:00 PM by Shane Devenshire[_3_]	2	123
Rolling 12 month total by MH Hi, I have searched to message boards and can't quite find what i'm looking for. I'm trying to keep a 12 month running tally (When I enter the information for...	June 29th, 2009 06:52 PM by Lars-Åke Aspelin[_2_]	7	158
cell w/ drop down then reference by Jackie K, I have a drop down box in "Tracking" workbook B3 with "Part Numbers". When I choose one of the part numbers from that drop down box I want C3 ("Current...	June 29th, 2009 06:51 PM by T. Valko	5	119
how do i remove an excel link that break link won't remove by brosull Is there a way to do this without buying 3rd party software?	June 29th, 2009 06:34 PM by Shane Devenshire[_3_]	1	177
Excel should allow at least 2 vertical and horizontal splits. by wmichaux I often would like to see data at the beginning, end, and middle of a worksheet simultaneously (either vertically or horizontally). It would be nice if I...	June 29th, 2009 06:05 PM by Shane Devenshire[_3_]	1	101
Hyperlink to a specific place in a document by Al Hello How do I hyperlink to a specific portion of a document? Either by page or more preferably page and paragraph. Thanks	June 29th, 2009 05:53 PM by Dave Peterson	3	97

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed