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 Reverse Sort Order Last Post Replies Views
Help with array lookup and max by DavidFarnsworth
Ladies and Gentlemen, If someone would assist me in adding a max formula to this array without adding any columns I would appreciate it...
January 22nd, 2007 05:58 PM
by Roger Govier Go to last post
1 47
Lookup Formula help by DavidFarnsworth
Hello, I have a formula that results with 2 rows of data spread across 9 columns. The first row contains text. The second a value. (Text Text Text Text ...
(Multi-page thread 1 2)
January 22nd, 2007 06:13 PM
by DavidFarnsworth Go to last post
10 125
calculating timesheet, time-in/time-out = total hours & minutes, . by Davidfrost
"Steve Lindsay" wrote: Need to create an Excel Timesheet that calculates the hours and minutes worked daily, based on the time-in/time-out. Then allow the...
January 26th, 2005 02:37 PM
by Davidfrost Go to last post
0 213
How to group e-mail adresess based on domain name? by DavidG
Hi, I have a spread sheet with a large number of E-mail adresses we are using for an e-mail out and i was wondering how i can group them based on the domain...
September 4th, 2008 06:01 AM
by Joerg Mochikun Go to last post
2 72
Linking data from Rows to columns in seperate worksheets by davidge
I cannot find a way to quickly link data in rows from one worksheet to columns in another without using the hold = button select cell method-- which is very...
August 11th, 2007 10:37 PM
by T. Valko Go to last post
1 68
How do I link data from a horizontal range to a vertical range? by davidge
How do I link data from a horizontal to a vertical range when the ranges are in different worksheets of the same workbook. I have used the =INDEX(xx:xx,...
May 25th, 2007 08:06 AM
by Roger Govier Go to last post
3 73
copy info from another sheet by Davidgg
I am using a column in sheet1 that I input the info, and I need that this info go to another sheet2 and then print it. Return to sheet1 continue the...
December 18th, 2006 11:04 PM
by Davidgg Go to last post
5 61
perform calculations in 2 sheets by Davidgg
I have 2 sheets, in sheet1 I will be input info, and I need that when I input for example :15, this appears in sheet2 sum the total and print it. Next: Go to...
December 20th, 2006 04:39 PM
by Davidgg Go to last post
0 62
Search Function that returns an integer not #VALUE! by DavidH
Hi I'm trying to use a logical function to search text in a cell, see below =IF(SEARCH("DENTAL",A3,0) = 0, IF(SEARCH("VISION",A3,0)...
March 28th, 2007 04:26 PM
by Ron Coderre Go to last post
2 47
Pls help me!! by davidiew
Hallo there! Pls refer to the attached file (01) Filename = "Auto Update". How can I have my cell in "yellow" to show TEXT + sum of month automaticlly while...
February 25th, 2004 09:02 AM
by Nicky Go to last post
1 91
How do I view formula results intead of formula in excel? by davidinatlanta
I have a spreadsheet that someone email me and I am trying to add a formula to it. Instead of the cell showing the results of the formula, it just shows the...
February 7th, 2006 04:02 PM
by davidinatlanta Go to last post
4 170
Help with lookup (vlookup) by davidio
I have a work book with 2 sheets in. One has a listing of drugs. Drug Abacavir Sulfate Abelcet Abilify Aciphex Actinex
July 27th, 2007 08:42 PM
by Harlan Grove Go to last post
1 65
value of a cell / expression is a whole number by DavidJ
I want to check if the value of a cell divided by a constant is a whole number or integer - can anyone help Thanks DavidJ
October 18th, 2007 11:05 AM
by Gary''s Student Go to last post
1 63
Concatenate or not? by DavidJ726
I need to take the contents of three cells and combine them to form a telephone #, but when a number in cell begins with 0's, the concatenation function...
April 26th, 2008 05:56 AM
by T. Valko Go to last post
4 93
Adding workdays as part of the equation by DavidJ726
I'm trying to put together a simple schedule in Excel and need to calculate x working days from a given date. So if cell A1 = the project start date, and I...
October 26th, 2007 03:20 AM
by DavidJ726 Go to last post
2 53
Conditional Formatting, reference another column by DavidL
I have two columns that I want to format with a background color when a certain condition is met for one column (column H). If the cell value which is a text...
April 7th, 2005 10:17 PM
by JB2K Go to last post
4 151
Counting values containing part of a cell by davidm
I have a list of dates and wish to count the number of times February appears. If I search for a specific date such as 03 February 2005 I have no problem but...
March 27th, 2005 12:17 PM
by davidm Go to last post
3 73
Q. How can I change this date by DavidM
Hi I have some dates like this:Sunday, 10 September 2006 in my worksheet, I've tried to change the format in excel with no luck. If they can be changed...
September 15th, 2006 03:53 PM
by Pete_UK Go to last post
3 53
Can you color cells with Array Formula? by davidm
If I have an assortment of odd and even values in range a1:j100, using the Array formula* {=If(Mod(a1:j100,2),"",a1:j100)*} will clear out all the odds,...
(Multi-page thread 1 2)
December 1st, 2005 01:35 PM
by Bob Phillips Go to last post
10 219
Conditional formatting from Dates by DavidM
Today's date will be manually entered in to a header cell. The worksheet contains the dates that customers last purchased from me. How can I change the colour...
June 11th, 2009 05:00 PM
by David Biddulph Go to last post
3 136
Post New Thread


Display Options
Showing threads 20101 to 20120 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 08:33 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.