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
need sumproduct to return text values... by jat
this is a follow up to my previously posted subject line: "vlookup (indirect, or sumproduct) using three tabs" i have a sumproduct working (sort of, but not...
April 18th, 2009 12:07 AM
by jat Go to last post
2 174
vlookup (indirect, or sumproduct) using three tabs by jat
i have a purchase order using three tabs. Sheet1: Cell A1 has a supplier name (is a drop down list based on a list from Sheet2. Cell A5 is a product code and...
April 17th, 2009 11:37 PM
by jat Go to last post
3 125
Breaking down a cell to create a function by Robert
I'm trying to create a flow graph by using current information on my spreadsheet. I have a column of dates in this format 01/05/06. I trying to find a...
April 17th, 2009 10:44 PM
by Teethless mama Go to last post
5 110
Vlookup by Dinesh
Hi, I have three columns in Sheet1. COL A has DM#, COL B has CM# and COL C has an amount. Sheet2 has two columns. COL A has DM# and CM#. In COL B, I like to...
April 17th, 2009 10:41 PM
by Sheeloo Go to last post
9 147
SUMIF based on several criteria. by Mike
OK here is what I want to do. I have three different values that I want to sum. I have several criteria that I have to consider when I sum them. A B ...
April 17th, 2009 10:01 PM
by Mike Go to last post
6 112
IF cell contains part of text by Supe
Want to create an if fuction that will give a result of "Yes" if any part of the cell cotains 16Z.
April 17th, 2009 08:31 PM
by Teethless mama Go to last post
3 93
Format for a cell with a formula in it but I don't want the 0 to c by texansgal
I am trying to format at worksheet and use formula's to reference a different page. What format can I use so that when there is no information entered in the...
April 17th, 2009 08:25 PM
by texansgal Go to last post
3 91
new macro to format worksheet by mclovin
I'm trying to record a new macro to hide specific columns & rows. I went to "record new macro" and went through the steps, but when I try to test out the...
April 17th, 2009 08:23 PM
by mclovin Go to last post
2 72
Sorting Unorganized Data Into Different Spreadsheets by Crinks
I'm attempting to take some very unorganized data and extract it into data that I can use in 3 different spreadsheets, all at once. This is for payroll...
April 17th, 2009 07:43 PM
by Crinks Go to last post
2 72
Reference previous worksheet within VLOOKUP by Alex Mackenzie
I have found several previous postings about this, but still cannot get my function to work. If I put the name of the previous worksheet (e.g. March 09!...
April 17th, 2009 07:20 PM
by Teethless mama Go to last post
2 75
Lottery function - how to randomly select cells by ap@rfr[_2_]
how to create function to randomly select names
April 17th, 2009 06:54 PM
by Luke M Go to last post
1 68
Copying formulas in range and pasting in a selection by Billy B
I cannot seem to figure out what is wrong with the following formula. I want to select a range of cells, copy only the formulas in that range and then paste...
April 17th, 2009 06:52 PM
by Billy B Go to last post
3 69
What is the function to randomly select a cell, like for lottery? by ap@rfr
Using Excel, I have a list of names and I need to randomly select one at a time. How do I create the function to do this?
April 17th, 2009 06:50 PM
by Teethless mama Go to last post
4 85
If Statement Question by Joe
=IF(D3=M3 and C3=M3,M3,"NO EXECUTION") The above is yielding #NAME? What is the proper syntax? Everytime I have a need for this evaluation I stump myself...
April 17th, 2009 06:19 PM
by BIG D Go to last post
4 61
Sumif linked to different workbook by JLC1952
I have numerous sumif formulas in a workbook (see example below), and they reference other workbooks. When I open the workbook with the formulas in it, they...
April 17th, 2009 06:08 PM
by T. Valko Go to last post
1 74
use Hlookup to look up two or more values by tywlam
How do I use hlookup to look up two or more values on the top rows and return a value in the same column from a row specified? (hlookup allows to look up one...
April 17th, 2009 05:55 PM
by Teethless mama Go to last post
5 100
Concatenating two variable fields into a static length text field by Young Programmer Lad
I have a spreadsheet with two columns of variable length text that I want to concatenate into a static length text field. The first column can be anywhere...
April 17th, 2009 05:39 PM
by Young Programmer Lad Go to last post
2 100
Data Validation by AaronMcG
Hello all, I am not an expert with excel. But i do use it very frequently. And lately i've been setting up a project for my company to standardize...
April 17th, 2009 05:16 PM
by Kassie Go to last post
1 63
Use Like in Vlookup by ryguy7272
Here is my function: =IF(ISNA(VLOOKUP(H12,'booked pivot'!G:H,2,FALSE)),0,VLOOKUP(H12,'booked pivot'!G:H,2,FALSE)) I am trying to get Excel to evaluate this...
April 17th, 2009 04:59 PM
by ryguy7272 Go to last post
4 130
roundup with index,match,subtract,divide and add formula by ladygr
Stuck again! Many thanks to 'toothless mama' for helping me modify my formula to this: =(INDEX(Sheet2!$A:$A,MATCH(A62,Sheet2!$F:$F,0))-C61)/2+C61 But, now I...
April 17th, 2009 04:56 PM
by Teethless mama Go to last post
3 78
Post New Thread


Display Options
Showing threads 12021 to 12040 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 06:31 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.