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
Conditional Formatting =IF($B10, TEXT("dddd"))? by [email protected]
I'm using Excel 2003. I'm trying to use conditional formatting to have a blank cell change to the day of the week when a date is entered into another cell.
January 9th, 2008 08:59 PM
by Gord Dibben Go to last post
6 111
January 9th, 2008 08:53 PM
by Susan Go to last post
3 89
How do I Propogate Cell Selection Pattern? by archsmooth
I imported from a database program, but now have a mix of language and data on my spreadsheet,a small sample follows: Task No. AF-1880M Description...
January 9th, 2008 08:31 PM
by archsmooth Go to last post
0 72
index/match or vlookup or similar by [email protected]
I am looking for a formula that will tell me min and max in column B and list the associated data from column A A B 1 Year Amount 2 ...
January 9th, 2008 08:16 PM
by CLR Go to last post
1 80
Link from 1 worksheet to 4 different worksheets by john
I'm trying to link one (1) Source data sheet row information based on Column one (1) criteria to seperate worksheets identifed/labeled as Column one (1)...
January 9th, 2008 08:14 PM
by CLR Go to last post
1 76
January 9th, 2008 07:54 PM
by Mike Middleton Go to last post
1 79
Confused about setting up functions based on variables? by NotExcelingNow
I have 7 lines of data, with 2 variables each. if variable #1 is solo the i need exel to produce sentence "A" with variable #2 in it. If variable #1 is =...
January 9th, 2008 07:31 PM
by NotExcelingNow Go to last post
5 118
IF, AND, OR Function by Pete_UK
You're welcome, Tom - thanks for feeding back. Pete On Jan 9, 5:47*pm, talltom wrote: Thank You Pete_UK. *It works...
January 9th, 2008 07:20 PM
by Pete_UK Go to last post
0 69
auto-complete from a drop down list and from a different workbook by [email protected]
I have thousands of suppliers. I don't want my employees to have access to all of the suppliers' information. Just want them to have access to name, number,...
January 9th, 2008 06:59 PM
by Gord Dibben Go to last post
1 117
can windows vista edit shared document from windows xp by sasa
i cannot edit shared document from windows xp to windows vista
January 9th, 2008 06:44 PM
by Gord Dibben Go to last post
1 72
Using the CountIf function with multiple criteria? by Jonathan
Hi all, I'm trying to use the countif function to count the number of items that have a specific name (column A), that has a "Yes Flag" for another field...
(Multi-page thread 1 2)
January 9th, 2008 06:34 PM
by Bob Phillips Go to last post
11 192
Countif text in individual cells by q3pd
I have d2, e2 and f2 with text in them. The text is either 'Physical' or 'Remote'. When they have 'Physical' in d2, and/or e2 and/or f2 I want a function in...
January 9th, 2008 06:25 PM
by David Biddulph Go to last post
5 93
Automatically update spreadsheet from another spreadsheet by Cindy
I have 8 sheets on one spreadsheet and I need to create individual spreadsheets for each of the 8 sheets. The problem is I need the information I put into...
January 9th, 2008 06:05 PM
by Cindy Go to last post
3 101
Opening an .mdb file in Excel by lehigh46
Hi All, Can anyone tell me how I can load an entire .mdb file into Excel file, which exceeds 65,536 lines. Thanks for any help you can give me.
January 9th, 2008 05:55 PM
by ryguy7272 Go to last post
2 103
IF, AND, OR Function by talltom
Hi everyone, The following is a formula that works in Quattro Pro. I am trying to convert it to Excel...
January 9th, 2008 05:47 PM
by talltom Go to last post
3 85
Days between dates including start day and weekends by JessP27
I need to find the number of days between two days, but I need to include the start date, and not the end date. For example: Start: 1/7/08 End:...
January 9th, 2008 05:32 PM
by Pete_UK Go to last post
7 133
Creating running clocks in multiple cells. by MikeG
I am looking for a way to use cells in a spreadsheet as live clocks. I want to be able to show the live times in multiple cities using the cells in a...
January 9th, 2008 04:50 PM
by CLR Go to last post
9 125
filter dates by quarter by Larry
I’m working on a spreadsheet for my payroll, in column “A” is a weekly pay period end date “I” is my gross pay for that week Holiday pay is figured...
January 9th, 2008 04:28 PM
by Larry Go to last post
4 81
Stop excel rounding my 16/17 digit numbers by E Halliday
I receive a report which has transaction numbers either 16/17 digits long. Is there anyway I can retrieve the full number from excel? Much appreciated.
January 9th, 2008 04:20 PM
by Pete_UK Go to last post
2 102
Hyperlink to Named Range Based On Cell Contents by TKS_Mark
I'm using the function below to make a hyperlink. The contents of 'A-Z Inputs'!AN5 has a named range in it. =HYPERLINK('A-Z Inputs'!AN5) When I click on the...
January 9th, 2008 04:14 PM
by Dave Peterson Go to last post
1 92
Post New Thread


Display Options
Showing threads 29941 to 29960 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:08 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.