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
#REF Error in Named Range with INDIRECT, SUMPRODUCT, and OFFSET by Greg in CO[_2_]
Hi All! I have run into an odd issue using a Named Range with INDIRECT, SUMPRODUCT, and OFFSET. I have a worksheet that has a formula which will look for...
October 13th, 2008 06:45 PM
by Greg in CO[_2_] Go to last post
6 93
How to extract text when it's included in the format? by gilliam
I have a worksheet that contains both numbers and texts. The cells have units of measurement attached to them, however, they're included in the cell...
October 13th, 2008 05:12 PM
by Rick Rothstein[_2_] Go to last post
3 92
How to get month number for fiscal year starting in Oct. by Tim
Does anyone know a formula that I can use to get the month number for a fiscal year that starts Oct.? Thnaks, Tim
October 13th, 2008 05:08 PM
by John C[_2_] Go to last post
3 69
How do I unprotect a spreadsheet? by Sofiya
I received a spreadsheet from my client and while I can view all the pages, I can only print some, even if I select print entire worksheet. How can I...
October 13th, 2008 04:30 PM
by John C[_2_] Go to last post
1 57
VLOOKUP with a Named Range argument by modernminstrel
I am using a VLOOKUP to refer to a table that is a Defined Name/Named Range. When I use the Defined Name directly in the function the Function works fine....
October 13th, 2008 04:11 PM
by John C[_2_] Go to last post
1 93
Hyperlink imported data into worksheet with dated formate by Derro
Hi My problem is a bit complex and I have an old brain so I will try and make it as clear as I can. I am setting up in 2003 however the final product will...
October 13th, 2008 03:53 PM
by Derro Go to last post
0 70
Adding suffix to column entries by NCdesigner
I have a column of 11,000 entries. These are stock numbers for a website store. The image that goes with each item has the same number. I need to add ".jpg"...
October 13th, 2008 03:49 PM
by NCdesigner Go to last post
5 59
Automating search and replace by Wellman[_2_]
I'm trying to do something simple, yet I can't figure it out. I have two spreadsheet. One includes company names and "codes": QWE843 | Apple FER244 |...
October 13th, 2008 03:43 PM
by Sheeloo[_3_] Go to last post
2 54
Countif based on two criteria by MJKelly
Hi, I have a number of duties which I have broken down by tasks. I want to summarise the amount of different tasks for each time window for each day. I have...
October 13th, 2008 03:39 PM
by MJKelly Go to last post
4 70
how to change one valuta ex. doller to euro by Frost
how can I change the valuta in a Shiet from one valuta to an other? Best Regards Frost
October 13th, 2008 03:39 PM
by Sheeloo[_3_] Go to last post
1 59
SumIf conditional to date range by IlliniDan
I have the following data set: A B 1 10/7/2008 2 3 10/1/2008 92 4 10/8/2008 59 5 10/17/2008 31 6 10/22/2008 42 7 10/29/2008 28
October 13th, 2008 03:33 PM
by IlliniDan Go to last post
5 86
Simultaneously use VLOOKUP and HLOOKUP in EXCEL 2003 by Nicky
I am trying to get data from a Sales Forecast into a planning sheet. Dates are across the horizontal rows and product codes are on the vertical columns...
October 13th, 2008 02:57 PM
by Nicky Go to last post
3 101
Problem w/vlookup by Sandy
I have created a employee absentee form. In comment area, want to type in number from range that automatically types in description from same...
October 13th, 2008 02:05 PM
by John C[_2_] Go to last post
5 60
Totaling functions in Excel by SueL
Hi I need to add totals with logical functions in an excel spreadsheet I have a list of books, teachers, classes etc and I need a function that will lookup...
October 13th, 2008 11:50 AM
by SueL Go to last post
2 80
Identifying and totaling up duplicate cells in Excel by Paul
Hi can anyone help me?? I have two worksheet (1 & 2) with telephone numbers in column 'A'. What I need to do is run a macro in sheet 2, that will identify...
October 13th, 2008 11:09 AM
by Paul Go to last post
2 59
Validation Formula only worked once. by Rick Arends
I have a drop down list in cell B40. In the validation I wrote =If(A40="","",FORTYB) where "FORTYB" is the name of a list. It worked perfectly, only filling...
October 13th, 2008 10:54 AM
by Max Go to last post
2 84
Contitional Formatting - Can I Make One Cell React To A Range? by IanC
In conditional formatting use formula is, then something like this: =COUNTIF($A$1:$A$10,"4")0 This reacts if there are any values in the range below 4 --...
October 13th, 2008 10:51 AM
by Bob Phillips[_2_] Go to last post
1 61
SUMPRODUCT arguments by Chris T-M
Working with SUMPRODUCT for the first time. Can someone explain the use of the dashes following the command? I've seen from none to (I think) 4... I started...
October 13th, 2008 10:49 AM
by Bob Phillips[_2_] Go to last post
3 70
How to extract anitials from an email adresse? by Tippo22
Hi, i need some help extracting initials from email adresses. All adresses have the same domain name @qwertyui.dk but they have different lengths of...
October 13th, 2008 10:26 AM
by Tippo22 Go to last post
4 55
lookup database by ellebelle
Hi, I have a database S = 5 UM = 4 MM = 3 LM = 2 J = 1
October 13th, 2008 09:17 AM
by Pete_UK Go to last post
3 63
Post New Thread


Display Options
Showing threads 19201 to 19220 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 05:15 PM.


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