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
Matching & adding text in the respective column by ashutosh
I have text data in following way high india high australia low russia medium france medium ...
April 23rd, 2009 12:53 PM
by Jarek Kujawa[_2_] Go to last post
1 91
Conditional formula with multi tasks by BadBoy
Hello all, The formula below will add the number in cell A1 from a workbook called ‘Monthly Totals’ to A1 in a book called ‘Yearly Totals’. Is there...
April 23rd, 2009 12:48 PM
by BadBoy Go to last post
1 71
formulas do not work by Baracuda
Look I am new to Excel so I will try to explain my problem on the example. I have 1 big spreadsheet called "company" (where I keep all expenses like diesel,...
April 23rd, 2009 11:21 AM
by Baracuda Go to last post
2 71
Formula behind functions by VolkerB
Hello, my question belongs to worksheet-functions beginning with coup, for example coupncd or couppcd and so on. Is there any hint, how these functions...
April 23rd, 2009 11:14 AM
by VolkerB Go to last post
3 96
Concatencation and formatting by Bengt[_3_]
I am trying to concatenate two cells. One of the cells is formatted using the "Special" option on Format Cells. The formatting I have been using is the one...
(Multi-page thread 1 2)
April 23rd, 2009 11:13 AM
by Ron Rosenfeld Go to last post
17 117
Using V or H lookup by katiapro93
Hi, I have a chart which is a price list. in one column I have the size of the product, next to it is a column with the product name, and next to it is a...
April 23rd, 2009 10:32 AM
by Pete_UK Go to last post
3 83
Converting time to number, i.e. 2:32 to 2.32 by Kokomojo
I'm figuring song royalties based on the length of the song. My songs are listed in minutes/seconds, such as 2:32. In order to calculate the royalty, I...
April 23rd, 2009 10:23 AM
by Pete_UK Go to last post
7 71
How to get text which is inside the brackets in excel sheet by arun
Hi all, I am having field values like below, xyz(xxx) abc(rrrr) pqr(as) my need is to get string which is inside the bracket. xxx
April 23rd, 2009 10:18 AM
by David Biddulph Go to last post
2 100
compare two or more ranges by tywlam
How do I locate cells in a range where data is missing or mismatched with other cells in another range? Thanks.
April 23rd, 2009 10:18 AM
by Stefi Go to last post
3 115
List Box and IF function by Jenny Beech
I need to use the results of a list box choice in an IF statement. How can I do this?
April 23rd, 2009 07:32 AM
by Joerg Mochikun Go to last post
1 94
conditional formatting based on different cells with more conditio by sarajane82
I'm trying to get conditional formatting in the cells in one column. I want them to be blue if the cell in front of it contains the value "N/A", I want it...
April 23rd, 2009 07:29 AM
by JBeaucaire[_92_] Go to last post
1 77
linked data by nidabland
I have the following information on one worksheet that I need to transfer to a new worksheet in another format. Refer Acct Amt 80312 43700 -36,500.00 80312...
April 23rd, 2009 06:17 AM
by nidabland Go to last post
0 70
Define cell value in a matrix to add up 2 constraints value by gila_cokelat
I have a matrix to match same SUM value (550) from left-right and up-down X...
April 23rd, 2009 04:10 AM
by gila_cokelat Go to last post
0 119
Compare ranges by tywlam
How can I locate the cells where the data is missing or not matched with other cells in another specified range? Thanks in advance.
April 23rd, 2009 04:07 AM
by tywlam Go to last post
0 59
Cleaning a list in Excel by Shawnt
I need some help in deleting rows from a list by comparing two lists. I have two worksheets and both contain the same type of info. Just First Name, Last...
April 23rd, 2009 04:00 AM
by Shawnt Go to last post
1 80
display first or second match instead of #REF in INDEX ROW formula by seapilot
Greetings, I have a formula to extract data from a 3 column worksheet (SKED) into monthly calendar worksheets (MAY, JUNE, etc.). ...
April 23rd, 2009 03:04 AM
by T. Valko Go to last post
9 95
Custom Number Format by TeddyTash[_2_]
Hi, Hope you guys can help. If I have the following info: A1 = 5 A2 = -4 A3 = 0
April 23rd, 2009 02:41 AM
by Dave Peterson Go to last post
2 98
create table of selected rows by TBA
Hi there. I have a sheet 'patients' with 'A' Row being an ID taking the form S002, S003 etc. I have another sheet 'selected' with a selected list of IDs in...
April 23rd, 2009 02:20 AM
by TBA Go to last post
1 73
Conditional Function by Lisa H
I am trying to create a formula that will multiply a portion of a cell by a percent and the other portion by another percent. For example, when the value...
April 23rd, 2009 02:14 AM
by JLatham Go to last post
4 89
sum table by Bonita
Need a single formula that will return the sum of all items lbs/hr (lbs*rate)/hours Goal is not to have Col D as lbs/hr and total the column ...
April 23rd, 2009 01:27 AM
by smartin Go to last post
1 72
Post New Thread


Display Options
Showing threads 11841 to 11860 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 11: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.