A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Find second to last value in cell by Eric_G
Unless most "right" or "left" functions in which one is looking to select the "LAST" or the "FIRST" value within a string of characters within a call, I wish...
April 25th, 2010 05:50 PM
by Bob Phillips[_3_] Go to last post
4 243
List the UNIQUE certain fields from the database by Andri
Dear Experts, Please help related to the above subject. From this discussion, got the following formula which is work well and faster for small of...
April 25th, 2010 05:12 PM
by Dana DeLouis[_3_] Go to last post
5 237
Sumproduct with mixed data? by gooders
Hi, I have a column that is predominately filled with dates i.e. 1/12/2010; 16/4/2010 etc, and my formula below counted the number of rows based upon the...
April 25th, 2010 03:42 PM
by T. Valko Go to last post
6 218
how do I copy the last 20 entries in an expanding list by DJA
Within a macro, I need to copy the last 20 entries of a list to another location. as the list grows, I still only need the last 20 entries to copy to the...
April 25th, 2010 02:54 PM
by Teethless mama Go to last post
4 127
Percentages in Pivotal by JoeM
I have a pivot table I want to do percentage of total on: Column 1 Column2 Ice Cream 32 Cake 50 Total 82 I want to...
April 25th, 2010 11:10 AM
by Ashish Mathur[_2_] Go to last post
3 145
How do I use a percentage formula? by MeursaultO
Currently I am working on an assignment and need to turn a whole column (approx. 153 cells) into a individual percentages of one cell. Every time I tried...
April 25th, 2010 10:22 AM
by Ashish Mathur[_2_] Go to last post
3 128
Reference: forum discussion dated 17-18April2010 by Andri
Dear Ashish/Experts, I have downloaded the addin from the below link. thank you for your excellent External Excel Function, which is workable 100%. but i...
April 25th, 2010 10:09 AM
by Ashish Mathur[_2_] Go to last post
3 115
how to remove all formatting by Tom
I am working on office 2007 prof - my spreadsheet should be read by colleagues using 2003 and ideally 2000 versions. While I was able to save the file as xls...
(Multi-page thread 1 2)
April 25th, 2010 08:50 AM
by XLGeek[_2_] Go to last post
14 255
Drill down via page fields by Roland Grothe
I'm quite new to Pivot-Charts, so i need some help. I use a quite simple table with Employees, segments, OrderValue, Date (only months) and products. Every...
April 25th, 2010 02:07 AM
by Herbert Seidenberg Go to last post
1 141
how to sum cells and ignore the #div/0! 's ? by abdul gaffoor
"Todd" wrote: I have a column of data that links to another sheet I need a ytd total for. The problem is that the cells contain formulas (on the feeding...
April 25th, 2010 12:31 AM
by abdul gaffoor Go to last post
0 188
VLOOKUP in VBA by G.P.N.L. c.v.a.
I am a beginner in VBA; nevertheless, I already have several working UDF's in Excel 2003, though. Why does TGI(A213) gives me "#VALUE!" - while A213 contains...
April 24th, 2010 11:55 PM
by Dave Peterson Go to last post
7 157
Rounding Seconds in 4/21/2010 4:30:23 PM by Tom Langley[_2_]
I am trying to round the seconds portion of a column of cells containing both date and time. Currently the cells contains: 4/21/2010 4:30:23 PM 4/21/2010...
April 24th, 2010 11:04 PM
by Joe User[_2_] Go to last post
5 142
Head scratchin for hours.... Help with a formula please... by Bill Needham
1 workbook-54 sheets. One sheet per week. On that sheet I need a way to track state mileage. 48 states. might be in a state 6 or 7 times and the all of the...
April 24th, 2010 10:11 PM
by T. Valko Go to last post
6 141
Excel formula help needed! by Pat Convey
Hello everyone, I would like to create a formula that would calculate a different levy charge dependent on the amount. The example is below and any help...
April 24th, 2010 07:21 PM
by Ron Rosenfeld Go to last post
3 199
Cells Are Not Updating by PA Valley
All of a sudden the formulas in a cell are not updating. I have read the posts rid the fix and nothing happens. Only by going to the cell, clicking on the...
April 24th, 2010 04:02 PM
by Gord Dibben Go to last post
2 143
Count the frequency for every change in numbers by Elton Law[_2_]
Dear Expert, Would like to count the frequency each time it shows up . Below is the example .... 4 shows up 3 times ... 5 shows up 1 time ......... etc etc 7...
April 24th, 2010 03:58 PM
by Elton Law[_2_] Go to last post
6 166
Format Data Labels by ela
In Excel 2007 pie chart, there is an option called "format data labels" to let you determine what types of information to show. Unfortunately, whenever you...
April 24th, 2010 03:20 PM
by ela Go to last post
0 126
Formulas not updating by Creating a Database in VWD
Hi, I am copying my sheets and changing there names. For instance, I have sheets in this order: May 1 - Day and May 1 - Night. May 1 - Night has formula...
April 24th, 2010 12:42 PM
by Dave Peterson Go to last post
2 127
Saving & Removing VB Code from WB by NoodNutt
Hi everyone 1. I'm looking for something in VB that will save a copy of my workbook "in the background" to another location on a network drive. 2. During...
April 24th, 2010 11:56 AM
by NoodNutt Go to last post
4 120
Daily totals from a monthly log by Dhardy
I am working on a stat log that needs to provide daily, weekly and monthly totals for each staff member. I need excel to sum the dollar amouts in P6:P1000...
April 24th, 2010 03:05 AM
by Teethless mama Go to last post
1 146
Post New Thread

Display Options
Showing threads 1021 to 1040 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 03:03 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.