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
Combining Cells by George Perrotta
I have 4 cells that I need to combine into one cell. One cell has a time in it. When I combine cells it does not come up as time but a fraction. A1 8:30 B1 ...
April 12th, 2010 07:10 PM
by tompl Go to last post
2 125
Change formulas in a column based on a selection. by Ephraim
I have checkboxes from the forms toolbar in Column A linked to corresponding Cells in Column B. I have this formula in the corresponding cell in Column...
April 12th, 2010 06:21 PM
by Ephraim Go to last post
3 132
sumif - with 2 conditions - rows and columns by UKMAN
Hi SUMIF(Jan!$BY$3:$DL$3,Projects!$C6,Jan!$BZ$263:$BZ$266) this formula seems to work but only returns the number from BZ263 not the sum of the whole...
April 12th, 2010 05:58 PM
by UKMAN Go to last post
2 131
Combine several spreadsheets with multiple worksheets into 1 file by jydoug
Is their a way to combine several different spreadsheets with multiple worksheets into one file. I want one large file that you can open and view several...
April 12th, 2010 05:50 PM
by Ron de Bruin Go to last post
5 189
different colour font in same cel by ILMER57
I have a cell in excel containing a string of text with some characters in black some in green and some in red. I want to remove all the black text leaving...
April 12th, 2010 04:57 PM
by JLatham Go to last post
4 136
Counting Array element by asingh
Hi There, i have two columns, strategy, month and third is desired output STRATEGY month desired output cta ...
April 12th, 2010 03:30 PM
by asingh Go to last post
4 149
Format cell based on cell color by Jim
Is there a way to format the cell in column A "Red Fill" if there is any cell in that row in columns B through AO that have a Red filled cell? If not, is...
April 12th, 2010 03:00 PM
by Jim Go to last post
3 112
using if in a range by Sai
I am trying to workout numerology in excel: I have number 1-9 in row - 1 Alphabets A-I in row - 2 Alphabets J-R in row - 3 Alphabets S-Z in row - 4 I wish to...
April 12th, 2010 02:39 PM
by Teethless mama Go to last post
4 76
Basic Question on autocomplete function by kimmyhendrix
Hi everyone, my first time on the forum and my first thread. I apologize if this is already located on the forum here. I tried searching, but came up with many...
April 12th, 2010 02:22 PM
by Roger Govier[_8_] Go to last post
2 132
formating by JCRICKET
How would I format several cells to change color is one particular cell equals A?
April 12th, 2010 01:44 PM
by Dave Peterson Go to last post
1 85
Count if if by JCRICKET
I need to count the number of items that meet a certain criteria in two different cell arrays. I am having serious trouble figuring this out. I would like...
April 12th, 2010 01:38 PM
by Dave Peterson Go to last post
1 68
Consolidate excel 2007 by Glenn
I have cosolidated 26 sheets all in the same book with the sum function, top row left column. Most of the consolidation worked OK but 4 totals are incorrect....
April 12th, 2010 01:36 PM
by Dave Peterson Go to last post
4 111
If function with calculation by Charlie
Hi All, I need to get a result from the following: IF B20 = 0,0 IF B2035, 35 IF B20 35=B20 Basically in layman terms if B20 has a value above 0 the...
April 12th, 2010 01:35 PM
by Charlie Go to last post
4 91
Merge Cells by CarlainCerebroMode
I Just want to know how to merge via code two cells: This doesn't work: oSheet.Range.merge:=true;
April 12th, 2010 11:43 AM
by RonaldoOneNil Go to last post
1 77
Help With A Spreadsheet for a silent auction by Ken P
I am trying to create a spreadsheet to help with a silent auction. What I would like to do is enter the winners bidder number as well as the winning bid in 2...
April 12th, 2010 09:09 AM
by Steve Dunn Go to last post
1 93
Return column header based on last value in row by C.[_3_]
Hi all, Have data that looks like this: Status 02-10 Status 01-10 Status 12-09 Status 11-09 A 4 2 2 B 7 ...
April 12th, 2010 08:53 AM
by Steve Dunn Go to last post
3 82
sumif.. by nordiyu
my condition is : A B C 1 Date Name $ 2 15/2/10 John 15 3 16/2/10 ...
April 12th, 2010 08:25 AM
by Ashish Mathur[_2_] Go to last post
3 71
Counting frequency in unsorted data by PhilC
hi...I'm looking for a function that will count frequency using multiple variables in an unsorted data set using two variables. I can get the information...
April 12th, 2010 06:31 AM
by PhilC Go to last post
2 99
Look for Max and second Max by Elton Law[_2_]
Dear expert, Have made a similar post before. I am looking for the highest and the second high after the first highest. One of the experts replied me In Cell...
April 12th, 2010 06:21 AM
by Elton Law[_2_] Go to last post
0 74
Extract if 1 shows up by Elton Law[_2_]
Dear expert, I have a if function command, if fulfil will show up 1 in coulmn AD. I would like to extract if Column AD shows 1, then return figures on the...
April 12th, 2010 05:16 AM
by Ashish Mathur[_2_] Go to last post
3 117
Post New Thread


Display Options
Showing threads 1361 to 1380 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:57 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.