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
Sum in a column if there are 3 conditions in another column by DogmaDot
I need to find the total from Col B if Col A is one of the 3 possibilities A B DONE 0 DONE 60 OBS 40 POST 55 DONE 40 DONE 0 DONE 47
May 24th, 2010 04:35 PM
by Dazed&Confused Go to last post
5 248
Multiple IF statment help by Mark D
Morning all Having some trouble in getting a formula together. Am hoping someone can help me I have to put a formula (believe it to be an if) which has 3...
May 24th, 2010 04:33 PM
by Roger Govier[_8_] Go to last post
7 195
from the text 4 pcs., how to remove only characters/text by chriswyn
Pls help me in the above subject i.e. from the cell contents in excel as "4 Pcs.", what is the formula to be used to remove only number and mention in a...
May 24th, 2010 04:24 PM
by Steve Dunn Go to last post
1 192
Extract multiple numbers from a cell by Pomona
Here are some examples of text with multiple numbers embedded: A1 = 3031 // 2841;1886-ring road location A2 = 3305 //1455-historical A3 = //3491;3492 A4 =...
May 24th, 2010 04:06 PM
by Steve Dunn Go to last post
3 161
matching full name to 'two column' name using sumproduct by Carrach
Assume your names in Sheet1 are in column A, the dates are in column D, and the values you want to add are in column F. Further assume that the target_name...
May 24th, 2010 02:32 PM
by T. Valko Go to last post
9 411
=NameCheck - Monday??? by Lost Cluster
How do you write a formula for this: =NameCheck - Monday I’m looking for the correct syntax for writing a formula that deletes or omits names from a list?...
May 24th, 2010 02:28 PM
by T. Valko Go to last post
3 208
How do I export a Pivot Table in Excel into Word? by bananagirl
Please tell me how to do this.
May 24th, 2010 02:27 PM
by bananagirl Go to last post
0 227
drop down list by drop down list with related values
hi all, i am currently trying to create a worksheet which would have a drop down list containing descriptions from the description column (i.e....
May 24th, 2010 01:50 PM
by Luke M[_4_] Go to last post
1 333
possible countif formula? by Mark D
Hi Again everyone I am trying to get a formula in (possible countif) which doesn't seem to be working In column D I have the following dates D42 ...
May 24th, 2010 01:34 PM
by Ashish Mathur[_2_] Go to last post
3 323
Referencing more than 2 sheets in one cell function? by Alex
I am trying to take information from four different sheets in my workbook to create one function in my fifth sheet. So far, the function works with...
May 24th, 2010 01:28 PM
by Alex Go to last post
2 267
in MS EXCLE how we can protect only one cell? by anu khan
plz do repl me soon
May 24th, 2010 12:37 PM
by trip_to_tokyo[_3_] Go to last post
2 211
update workbook links over network by carlh
Hi i have 2 workbooks one is where i can enter details in to it called planner, i have a second called display where i have paste linked cells from planner...
May 24th, 2010 11:07 AM
by trip_to_tokyo[_3_] Go to last post
1 320
How can I lookup when match has more than one value? by bonot1
I am using LOOKUP functions to retrieve info from a list. Some of the lookup values have more than one match in the list. Is there a function that allows...
(Multi-page thread 1 2 3 ... Last Page)
May 24th, 2010 10:00 AM
by Roger Govier[_8_] Go to last post
55 2,490
Conditonal Format based on multiple criteria by Huggy
How do you format a cell if the data in the cell contains 1 of several buyers out of a greater list of buyers. One column in my spreadsheet contains the...
May 24th, 2010 09:25 AM
by Huggy Go to last post
2 311
Excel Help by Michel
I am an assistant accountant I would like to become an expert on excel programming. Is there anyone who can help me to achieve my dream, so that I can help...
May 24th, 2010 06:55 AM
by Rick Rothstein[_2_] Go to last post
3 241
Lookup / Array Range / find the value by The Hit man
I have seen similiar examples but not that were not using exact matches to retrieve data. This seems simple and maybe I am over thinking but I have been...
May 24th, 2010 05:34 AM
by The Hit man Go to last post
4 327
Tennis Scorecard Help by airolg
The ultimate goal is to rank each player after each match so that I know from week to week who the top three are. After the matches, we are going to do a...
May 24th, 2010 03:42 AM
by Brad Go to last post
1 165
How to look up a value? by Kipi
I have two column like this: A B 1 23 2 21 4 20 1 19 4 18 ....etc (The numbers in column A are random and do...
May 24th, 2010 12:46 AM
by Ashish Mathur[_2_] Go to last post
9 181
Minimum nonzero value for non-adjacent columns by Catalin
Dear Friends I use Xls 2003 and I would like to ask for help in the following problem: I have separate (non-adjacent) columns of data. I need to extract the...
May 23rd, 2010 02:34 PM
by T. Valko Go to last post
9 465
Sumproduct formula by Krish
I have the following columns in a table. Customer # Product # Invoice # Pack Size For every Product shipped to a customer we want to charge a lump sum fees...
May 23rd, 2010 10:59 AM
by Tom-S[_2_] Go to last post
1 213
Post New Thread


Display Options
Showing threads 361 to 380 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 09:29 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.