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
If & Vlookup statement by Sarah
I am trying to lookup 2 separate ranges based on the IF statement. For example If B3="PWR-PHYS" then I need it to lookup(A3,'DatePivot'!A1:B20,2) But if B3...
April 16th, 2010 08:13 PM
by Mitch Go to last post
3 218
networkdays issue by AJ
This is my Q838 field: 3/3/2010 4:06:08 PM This is my T838 field: 3/3/2010 8:22:42 PM This is my function:...
April 16th, 2010 07:10 PM
by AJ Go to last post
8 213
How can I add the values based the color of font and the date by Peter Gonzalez[_2_]
Hello, I wanted to know if it was possible to add the values of cells based on the color of font. And while doing this I also need it to do it based on the...
April 16th, 2010 07:01 PM
by Bernard Liengme Go to last post
1 201
Identify the windows just below the menu by Luismo
I am writing instructions for non-users of excel and need to identify the windows just below the menu. specifically the one that identifies what cell is...
April 16th, 2010 06:08 PM
by Dave Peterson Go to last post
2 158
concatenate by rpmani
I want to combine three cells with 'Concatenate' function and get the result like cell A1 = 10 (emp code) cell B1 = filename.xls cell C1 = sheet1'!A1 my...
April 16th, 2010 06:06 PM
by Dave Peterson Go to last post
2 146
Using text and formatting sum function in formula by Billy B
I am attempting to show text in a cell concatenated with the sum function and it works fine. The problem is the result has 10 decimal places in the resulting...
April 16th, 2010 05:53 PM
by David Biddulph Go to last post
3 147
Finding the lowest cost for a product from a list by tt
I have a list of products with the cost of each (each product appears on the list multiple times with varying costs). I need to create a formula that will...
April 16th, 2010 04:30 PM
by Squeaky Go to last post
2 184
formatted cells by medina
cells are formatted a certain way i.e. with formulas or dates. On more than one occasion when i close the worksheet and reopen, the cells are formatted...
April 16th, 2010 04:29 PM
by medina Go to last post
0 158
Dynamic Filtering...Need Help by cmeyer
Using Version Excel 2003 I have a report that retrieves different data based of data validation. In each case there are rows that have no data and I want...
April 16th, 2010 04:08 PM
by cmeyer Go to last post
0 157
Can you sum the amount of type a word appears? by Scott_goddard
Trying to sum the about of type a risk is open....So i need a statement to say =SumIF(A1;A6=open,dont count)???
April 16th, 2010 03:34 PM
by getting old Go to last post
2 152
Formula by josvill2010
Hi, I was using Vlookup formulas and now of sudden the formula appears on the spreadsheed like if it was a text. What can i do to fix that? -- Thanks for...
April 16th, 2010 03:06 PM
by getting old Go to last post
1 143
Week ending Thursday formula by Laurence Lombard
I am looking for an elegant solution for a week end Thursday (or any other day) formula: Up to now I have successfully used the following formula for "week...
April 16th, 2010 02:43 PM
by Ron Rosenfeld Go to last post
4 130
Finding NEXT to last, non zero numeric value in a row by gergster
trying to find a way to automatically return (via formula, not macro- I don't know squat about macros), automatically return the NEXT TO LAST, non zero,...
April 16th, 2010 01:58 PM
by Steve Dunn Go to last post
3 159
Interval between now and next birthday by WilDeliver
I need to calculate the interval between a date next year and a person's next birthday after that. Sorry if this has been answered, but I can't find it. ...
April 16th, 2010 01:37 PM
by Chip Pearson Go to last post
3 173
Average numbers in noncontiguous columns ignoring 0's. by bean counter
I need to average numbers that are not in contiguous columns, and I need to ignore zeros. Is this possible?
April 16th, 2010 01:23 PM
by Steve Dunn Go to last post
2 125
comparing data in excel by Eightball
Using Excel 2003. I have two columns for each month in a spreadsheet. Column A is the item code and column B is the cost/item for last month. i then have...
April 16th, 2010 12:16 PM
by Steve Dunn Go to last post
3 165
Sumproduct with a twist by Pam
Hi, Per code below supplied by Max in post dated 1/1/09 "Calculating the sum of different categories over a given time period", I need a slight variation...
April 16th, 2010 11:26 AM
by Steve Dunn Go to last post
4 128
Sum of retuned valus as digits by Vinay Vasu
Hello there, I am using IF function to return values as digits. Now I need the sum of such digits in a coloumn. Pease help me to do this. Thank you Jeevan
April 16th, 2010 10:49 AM
by Mike H Go to last post
1 161
search a row for a word and if found by Vibeke
I have 4 columns (C to F) I need to search row by row for a particular word. If the word is found in a row, I need to return 1 in Column G or 0 if not found....
April 16th, 2010 10:09 AM
by Jarek Kujawa[_2_] Go to last post
2 202
Concentration Analysis by Phillip Olan'g
I'm analysing a set of data and I need to provide an out put that shows the count i.e. frequency and the sum. Consider the values below: local...
April 16th, 2010 09:57 AM
by Jarek Kujawa[_2_] Go to last post
3 148
Post New Thread


Display Options
Showing threads 1221 to 1240 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:01 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.