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
Lookup or Vlookup? by PJ Murph[_2_]
A B C D E F G Drawing # Date PICKS 1 ...
May 15th, 2009 02:26 AM
by T. Valko Go to last post
5 127
Sequence of Weeks in a month by Elton Law[_2_]
Dear Expert, Is there any functions that can identify the number and the sequence of week in a month please ? Weekday(A1) can only give Mon,Tue, Wed .... Say...
May 15th, 2009 02:20 AM
by Elton Law[_2_] Go to last post
4 71
Subtract 10 months from a Speficic Date by AHizon via OfficeKB.com
I have a spreadsheet with an Eligibility Date for Upgrades, which is 10 months after it was upgraded. I need to determine when the device was originally...
(Multi-page thread 1 2)
May 15th, 2009 02:08 AM
by Ron Rosenfeld Go to last post
11 106
Formula for attendance record by Preschool Mike[_2_]
On sheet one of my workbook I have my daily attendance record (e.g., date and names of children absent) on sheet two of the same workbook I have my yearly...
May 15th, 2009 01:02 AM
by Preschool Mike[_2_] Go to last post
5 62
Copy only letters, not numbers by Connie Martin
I have a huge long column of text---product codes, to be exact, that could look something like this: CNUB275X3 or PB24X275. What I need is a formula, which...
May 15th, 2009 12:37 AM
by RagDyer Go to last post
8 79
stacking if functions by Idaho
I use spreadsheets for recording measured dimensions. I am trying to set up my template so when I put the dimensoin in, it tells me if it is right or not....
May 14th, 2009 10:48 PM
by JoeU2004 Go to last post
1 73
Summing a column by Rooky228
I have a column of numbers - some with different colors. I'd like to sum just the green or the red, etc. How do I write a formula that somes only certain...
May 14th, 2009 10:41 PM
by T. Valko Go to last post
6 146
How do I find a match for three variables to determine the result? by SykesvilleJim
I have a table called “Dates” with data that looks like the following: A B C A 3 Spin Start date ...
May 14th, 2009 10:27 PM
by T. Valko Go to last post
2 79
Find the first or last populated column in a range by Commish[_2_]
I have a range of data, from columns C through Z. And I have about 100 rows of financial data. The rows represent projects, and the columns represents periods...
May 14th, 2009 10:16 PM
by Glenn[_6_] Go to last post
6 139
XL07 create data validation list containing the names of each shee by ker_01
I am helping a colleague who uses XL2007. Data reports are downloaded from a separate application, and each update is pasted into a new tab in Excel. Since...
May 14th, 2009 10:11 PM
by ker_01 Go to last post
0 132
Entering a formula using excel 2003 by dpalmer
This is my worksheet: A B C D row 1 date amount paid bal row 3 2/28/09 ...
May 14th, 2009 10:03 PM
by dpalmer Go to last post
0 87
Convert european foreign date format to US date format by EAL
I receive dates in the following format in column: dd.mm.yyyy I would like to convert the column to read mm/dd/yyy. Any thoughts?
May 14th, 2009 10:02 PM
by Dave Peterson Go to last post
1 95
How do I format every 140th row? by From the farm
I need to highlight every 140th row which, I assume, I would use conditional formatting but I don't know how to do it.
May 14th, 2009 09:56 PM
by Paul C Go to last post
2 107
Count based on two different criteria by dabnat
Sheet name Active column C has names of counties example: marion column H has the way something sold example: estate sale I need a count where column...
May 14th, 2009 09:21 PM
by T. Valko Go to last post
3 108
Toolbar built for 2003 not loading in 2007 by Bishop
The following code is three subs that create a toolbar, create a button for that toolbar, and a macro that runs when the button is pushed: Sub...
May 14th, 2009 09:05 PM
by Dave Peterson Go to last post
2 85
Vlookup by Lorry
I am using the vlookup function and need it to return the match for the next highest value, not the closest below the value. Example: Value is 61 and I need...
May 14th, 2009 08:31 PM
by Harlan Grove[_2_] Go to last post
3 110
Using INDEX & MATCH to VLOOKUP prior column by TraciAnn via OfficeKB.com
Hello! I use range names for all my functions and I'm trying to lookup a number (LeadID) in a column (TechUserID) on another sheet (same workbook) and...
May 14th, 2009 08:30 PM
by TraciAnn via OfficeKB.com Go to last post
5 74
Conditional formatting from one sheet to another by seasteel
I would like to use conditional formatting between 2 different sheets in the same workbook. I.e I have one sheet that should only present different colours in...
May 14th, 2009 08:17 PM
by JBeaucaire[_92_] Go to last post
1 96
sorting ranges of various column lengths, lookup values in columns by mrphinney
I work in Excel 2003. I have part numbers and work centers that repeat, with various column lengths. The PN-WC combinations are repeated for each work order...
May 14th, 2009 07:51 PM
by mrphinney Go to last post
0 97
Applying users to site/names by fgwiii
I have 20 or so excel workbooks that are created at an external source and downloaded to our server. Each workbook contains a site and names that belong to...
May 14th, 2009 07:38 PM
by fgwiii Go to last post
0 82
Post New Thread


Display Options
Showing threads 11061 to 11080 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 08:54 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.