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
Removing Special Characters by Cathy Landry
Hello, I exported to Excel 2003 my Outlook Calendar and now I have a lot of odd little square characters that I cannot remove. Any suggestions...
March 23rd, 2010 08:27 PM
by Cathy Landry Go to last post
2 142
macro shortcut help by ericaamousseau
Hello I have a Macro set up in spreadsheets I have made for multiple people. I have set it up so they can paste the info needed in a worksheet and then use...
March 23rd, 2010 08:01 PM
by tompl Go to last post
1 112
Vlookup, IF, concantenate, Right -- can all these be in one formu by SRH@Boise
I am trying to do a vlookup from one tab with the lookup value a combination of B and the last 4 digits of A. Comparing that value to the other tab that...
March 23rd, 2010 07:00 PM
by T. Valko Go to last post
6 124
counting function with weekdays only by LSG
I need a formula to show this result : The 3rd business (weekdays only) day after an application is taken. Can anyone help? -- -Liz
March 23rd, 2010 06:50 PM
by T. Valko Go to last post
5 152
SUMIFS using a text rage by Ziggy
I am still trying to make the conversion from 2003 to 2007. In particular I'm trying to understand the SUMIFS since they are more efficient than arrays. I...
March 23rd, 2010 06:41 PM
by Ziggy Go to last post
0 109
SUMIFS using a text rage by Ziggy
I am still trying to make the conversion from 2003 to 2007. In particular I'm trying to understand the SUMIFS since they are more efficient than arrays. I...
March 23rd, 2010 06:41 PM
by Ziggy Go to last post
0 141
Date Format by DaveMoore
A date has been entered in cell E4, 31/03/2010 but has been formatted so as to display as MAR-10. That's okay, that's what I want. I now wish to refer to that...
March 23rd, 2010 06:15 PM
by T. Valko Go to last post
1 124
Column Average Given 2 Criteria by AAA1986
I want to get the average for a certain column, given 2 different criteria. Right now I'm using this formula for one...
March 23rd, 2010 05:52 PM
by T. Valko Go to last post
4 123
annualize sales for remainder of year by Kelli
I have a figure for YTD Sales and am trying to calculate estimated annualized sales off of this. And, this will change monthly as sales managers update...
March 23rd, 2010 05:48 PM
by Kelli Go to last post
3 133
Lookup on a combo box by dp_amsafe_elkhart
I have a combo box in cell C2, with facility locations in it. In another cell i want to either have an if statement if it matches the name put in an...
March 23rd, 2010 05:37 PM
by T. Valko Go to last post
1 112
Lookup 2 values to return 1 by Sarah
Does anyone know if you can combine and IF, AND, and VLOOKUP. I need to lookup 2 different dates in a table and if both of those dates appear on one sheet,...
March 23rd, 2010 05:05 PM
by Sarah Go to last post
9 115
Link an entire Row with a Key Word by Link an Entire Row with a Key Word
I have an excel document that has thousands of rows, but only 3 columns. I need to know how to link over the whole row of data if a single word is used in...
March 23rd, 2010 04:28 PM
by Fred Smith[_4_] Go to last post
1 97
IF Multiple Conditions by LJ
A B C D E Color Total Time Total Time 2 Time Allowed Y/NO BLUE 1:22:33 2:22:33 ...
March 23rd, 2010 04:25 PM
by Luke M[_4_] Go to last post
2 110
date format error in cell by pat67
I have one cell that for some reason even though the format is set to general, when i put in say 2007-2011 i get a pop up box that says date format error. the...
March 23rd, 2010 04:14 PM
by pat67 Go to last post
1 112
How do I validate / verify the output from a spline curve by rip1956
Is there a way to validate the Spline function to be Part 11 compliant?
March 23rd, 2010 03:46 PM
by rip1956 Go to last post
0 112
HLOOKUP into another xls file by Paul Dennis
=HLOOKUP(Summary!F7,'Wk43'!$N$3:$S$3,1) The above works, however sheet which is WK43 in this example and the workbook changes everyweek hence I need to...
March 23rd, 2010 02:24 PM
by Max Go to last post
1 124
Excel 2003 Macro - Finding rows with data to copy by Debbie
Below is a recorded macro to copy data to another worksheet. Range("V7").Select Selection.AutoFilter Field:=20, Criteria1:="" ...
March 23rd, 2010 02:23 PM
by Don Guillett[_2_] Go to last post
1 142
DATEDIF FUNCTION NOT LISTED IN HELP by Asoka Walpitagama - Brandix College IT
Should you not include DATEDIF function in the Excel 2007 HELP. Its not listed even under the FORMULAS -- DATE & TIME FUNCTIONS Is there any reason...
March 23rd, 2010 02:23 PM
by Luke M[_4_] Go to last post
2 128
Publish interactive data to the Web using Excel (Problem) by Tommy Damsgaard
Greetings, im having some problems with publishing interactive data to the Web using Excel. I followed the instructions...
March 23rd, 2010 01:01 PM
by Tommy Damsgaard Go to last post
0 113
How to sort duplicates? by J.Scargill[_2_]
Hi, I have a Year to Date summary sheet with a long list of 18 digit barcodes in column F that increases weekly as data is sourced from our staffs individual...
March 23rd, 2010 12:55 PM
by J.Scargill[_2_] Go to last post
0 108
Post New Thread


Display Options
Showing threads 1881 to 1900 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 01:06 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.