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
Calling Bernie Deitrick by Hile
I sure hope this works! You helped me in this post: Help with Nested Range counts - microsoft.public.excel.worksheet.functions posted 8/21/08 Can you see if...
August 27th, 2008 08:37 PM
by Hile Go to last post
4 70
Finding a calculated Value across Columns by Nigel Wallis
Hi Does anyone know of a formula that will display the cell reference of a given value? Basically I have a schedule running across 4 years (Columns) and...
August 27th, 2008 08:28 PM
by Nigel Wallis Go to last post
2 99
HELP - I think I need a macro??? by Annette
I am using Office 2007 Prof. I am having to do a repetative action with many steps to 83 workbooks - (replacing months in a linking formula, ie Aug to Sept)...
August 27th, 2008 08:14 PM
by Annette Go to last post
0 94
Hyperlink link_location error by Cynthia Haggerty
Hello, trying to jump to a different page in the same workbook. I keep getting the error 'cannot open the specified file', though i am working in the...
(Multi-page thread 1 2)
August 27th, 2008 08:11 PM
by Cynthia Haggerty[_2_] Go to last post
15 212
Just a bad day in Excel by Geiss-Evans
items in cut/paste were lost where can I find them? I thought I had saved transferring from one workbook to another; when I went to open I found nothing was...
August 27th, 2008 07:45 PM
by ryguy7272 Go to last post
2 76
IF and Then Formula Help Needed Please by Dimple
I need some assistance. Here's what I'm trying to do: I have a column with years of service for all our employees, say it's column D. Column E needs to say...
August 27th, 2008 07:36 PM
by Dimple Go to last post
5 83
Call Center Talk Times by Randy Rich
I am struggling to get a column of talk times from our call center to total up. The format is 0:00:05, for example, and represents the output from the phone...
(Multi-page thread 1 2)
August 27th, 2008 07:35 PM
by ward376 Go to last post
12 186
How to extract capitalized group in text string by newbie
How would I extract the capitalized, 3 character group from a text string? I have 283 rows of text of varying lengths, each with a 3 character upper case...
August 27th, 2008 07:26 PM
by Ron Rosenfeld Go to last post
9 150
Pivot Table Design by dss
I am working in Office 2007. I am working on formatting a pivot table. I have used the "designs" to create a custom design to apply to all my pivot tables....
August 27th, 2008 07:22 PM
by Spiky Go to last post
1 76
Count the number of times specific text appears in a column by Nannie
I have a column of dates in various formats (sometimes the year is first, sometimes not). I would like to determine the number of times a specific four-digit...
August 27th, 2008 07:09 PM
by David Biddulph Go to last post
5 121
Nd help, Vlookup/formula by Jason
Here is my current formula =IF(ISERROR(VLOOKUP($B$99:$B$206,'Scanning Gun'!$M$2:$O$75,2,FALSE)),0,VLOOKUP($B$99:$B$206,'Scanning...
August 27th, 2008 06:50 PM
by Jason Go to last post
1 69
Associating a STATE or TIME with a phone number by charles770
At my office when I check my voicemails I use Excel 2000 to create a log sheet of all voicemails received. Then, I start calling people back. However, to...
August 27th, 2008 06:44 PM
by Hile Go to last post
5 151
Adding numbers based on date by Dyanna
I have a workbook that on the first workbook page has a column with a date (when a bid is submitted), then in another column the amount of that bid - on...
August 27th, 2008 06:38 PM
by Dyanna Go to last post
2 78
SUMIF and SUMIFS by Colts41
I have 2 workbooks (source.xlsx and destin.xlsx), each with multiple worksheets. In sheet7!m4 I have this formula: ...
August 27th, 2008 06:11 PM
by Colts41 Go to last post
0 79
array formula by RN Mark[_2_]
I want to use an array formula to count any value in one column that does not match the corresponding value in the previous column, however, sum of the cell...
August 27th, 2008 05:50 PM
by RN Mark[_2_] Go to last post
2 53
Calendar resizes when workbook is closed by jeff
I have an embedded calender in two columns, when i save and close the workbook, the size of the calender is smaller.
August 27th, 2008 05:42 PM
by jeff Go to last post
0 70
lookups by JoviGirl
I am trying to compare 2 different listings to see if any in list 1 is a client. My lookup will only return the client if the client is an exact match. How...
August 27th, 2008 05:32 PM
by Teethless mama Go to last post
4 64
Changing conditional sum format to "Sum If" by Gina[_3_]
I am currently using =SUM(IF(Data!$E$2:$E$1700=2467,Data!$Q$2:$Q$1700,0)) But I would instead like to reference cell B2 of the current worksheet rather...
August 27th, 2008 05:27 PM
by David Biddulph Go to last post
4 133
Reference a number from one cell in the text of another cell? by melbatoast
I would like to setup the following: cell A1: 2009E cell A2: =A1 earnings per share cell A3: =A1 net income Such that cells A2 and A3 read: "2009E earnings...
August 27th, 2008 05:17 PM
by David Biddulph Go to last post
4 98
Curious Phenomenon...Vlookup not matching by Eric @ BP-EVV
I have a vlookup that is retunring an "#N/A" for one item in a spreadsheet. I have added a "trim" function to the mix to get rid of extra spaces and it...
August 27th, 2008 05:14 PM
by Dave Peterson Go to last post
6 102
Post New Thread


Display Options
Showing threads 21061 to 21080 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 09:52 AM.


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