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
Drag Down Formula Incorrect by Disco3Stu
I've got a long list of text data in column A, and am using the MID command to extract one bit of data from each which is then inserted into four columns...
March 9th, 2010 11:35 AM
by Disco3Stu Go to last post
3 154
Future date with six day week including holidays by ajitexcel
can anyone help me with this a. how to get future date (like WORKDAY Function) but the formula should include saturdays as work day excluding sundays and...
March 9th, 2010 11:25 AM
by Roger Govier[_8_] Go to last post
1 150
arrange columns through sheet and multi sheets by m.mohie
good morning A B C D Equipment serial type model mudump 123 triplex ...
March 9th, 2010 10:09 AM
by Jacob Skaria Go to last post
1 142
Group information from several worksheets into one worksheet by FredDave
I have 55 sheets, each sheet has 11 questions (one per column b5- k5 which are exactly the same. Each sheet is for 1 person to enter details, entering a...
March 9th, 2010 09:57 AM
by Vijay Go to last post
1 165
Excel 2007 -- Dates in Pivot Tables in wrong order after refresh by Cormac Murphy
I am using excel 2007 to look at time series data via pivot tables. I am importing the base data from a csv flat file into a sheet in excel -- that all...
March 9th, 2010 06:00 AM
by Matt Geare[_2_] Go to last post
1 132
Import multiple photos into excel by shanelawler
I am trying to create a photo sheet that will allow me to import all photos in a directory into an excel spreadsheet. I want it to: Import all images in a...
March 9th, 2010 04:33 AM
by shanelawler Go to last post
0 270
Import multiple photos into excel by shanelawler[_3_]
I am trying to create a photo sheet that will allow me to import all photos in a directory into an excel spreadsheet. I want it to: Import all images in a...
March 9th, 2010 04:23 AM
by shanelawler[_3_] Go to last post
0 127
DGET only limited to 1000 Rows, but I need 8000 rows for DGET funt by Chiann Looker
my 2007 Office Home Basic, can only do 1000 rows of DGET function, after that it return to #VALUE!, can someone help me. Is anything to do with because of...
March 9th, 2010 03:36 AM
by Teethless mama Go to last post
1 138
Can a cell be turned on or off? by painter50
A1=B1*C1+D1 A2=B2*C2+D2 A3=B3*C3+D3 A4=B4*B4+B4 I would like to be able the have the total in any one of the A cells to add up only if the cell is click on....
March 9th, 2010 01:42 AM
by Don Guillett[_2_] Go to last post
1 141
Macros running with Validation Rules by Chris
I have a worksheet with Validation rules set. But what I need to set is a Macro that runs when the Validation Item List is changed to “Contracted” I...
March 9th, 2010 01:07 AM
by Chris Go to last post
2 104
Finding Average of last 5 entries by houndawg
I'm trying to figure out a way to make an excel spreadsheet that will help me out with my players golf scores. I'd like a spreadsheet that I can enter...
(Multi-page thread 1 2)
March 9th, 2010 01:00 AM
by T. Valko Go to last post
13 214
Need help with Excel formula by Firefighter Instructor
How do I create a formula that will return a number 1-10 depending on data entered ranging from 1-57. Example. I have 10 fire districts. Each district has...
March 9th, 2010 12:55 AM
by T. Valko Go to last post
4 110
Date abbreviations / extensions by Keyrookie[_55_]
Is there a way to have dates show with extensions like, "st", "nd", "rd", "th" when using the NOW() formula? In other words, when the date changes from the...
March 8th, 2010 11:59 PM
by Keyrookie[_57_] Go to last post
6 163
picture by raismisuaween
pictures pictures of web pictures picture of pictures of
March 8th, 2010 11:44 PM
by raismisuaween Go to last post
0 94
Dissect IF Statement by DP
Hi: I need help with this complicated IF Statement. Would you please let me know what the formula...
March 8th, 2010 10:44 PM
by Dave Peterson Go to last post
2 99
need Excel formula that figures out which data adds up to total by Kerri
I have 33 different dollar amounts listed along with their invoice numbers and I need to figure out how many of those amounts add up to a check that I...
March 8th, 2010 10:21 PM
by JLatham Go to last post
4 122
If not an exact match to left of comma, then ALERT by Steve
I have two separate data columns. Col B has only last name, and Col D has last name, comma, first name. I'd like ALERTs in the F column if everything to the...
March 8th, 2010 09:57 PM
by David Biddulph Go to last post
6 113
Multiple rate of pays by Denise
On a spreadsheet, the date worked would be in column A; employees' name are in column B. An individual maybe listed several times in column B . In column C...
March 8th, 2010 09:55 PM
by David Biddulph Go to last post
5 147
IF, AND statment by Karas
The long version this gets complicated... I have multiple worksheets which are based off of one original worksheet (current). The Original...
March 8th, 2010 09:48 PM
by Fred Smith[_4_] Go to last post
1 137
Formula Question - CountIf? by RS
I would like to do the following, but am at an impasse. I think this should be simple, but it isn't working. Any help is very much appreciated! I would...
March 8th, 2010 09:38 PM
by Fred Smith[_4_] Go to last post
4 135
Post New Thread


Display Options
Showing threads 2281 to 2300 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 04:37 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.