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
Search / Find Function by Harry C.
I would like Excel to count all my NY customers; e.g., Search("NY",B2) if the state code NY is found in a lengthy text field containing a name, address,...
June 16th, 2009 05:40 PM
by Jacob Skaria Go to last post
6 143
Create multiple sheets and pivot tables from single source by dave
Hi all, sorry for the length of this post, I'll try to keep things as simple as possible. I've been given the task of maintaining a spreadsheet with all of...
June 16th, 2009 05:20 PM
by dave Go to last post
0 149
COMMON NUMBERS by sood
I have lists of various telephone numbers in multiple coulmns containing different rows and there may be same numbers existing in these coulmns and rows. I...
June 16th, 2009 04:02 PM
by sood Go to last post
2 149
EXCEL by Yolande van der Westhuizen
I need a bit of help. Ive got a excel sheet, with lots of data for 200 patients (1 Patient per row). One test that was performed on these patients had the...
June 16th, 2009 03:58 PM
by Shane Devenshire[_3_] Go to last post
2 122
Linking Objects by Humble09
Hi, I would like to know is it possible to link a cells to one column. I have a person who has mutliple keys and I would like to list all those keys in one...
June 16th, 2009 03:54 PM
by Humble09 Go to last post
0 144
Error Message :A value used in the formula is of the wrong data ty by Graham
Just upgraded to Office 2007, trying to do a very basic spreadsheet and keep getting the above error message, and I cant see why ? I have a column, with...
June 16th, 2009 03:51 PM
by Shane Devenshire[_3_] Go to last post
4 116
Spell Check by Warm
Hi, can someone please explain why this proction macro does not allow the spell check function to work when the 'userinterfaceonly' option is in it?! Sub...
June 16th, 2009 03:30 PM
by Gord Dibben Go to last post
3 150
cell or column highlights when other cell is selected by Tropicana
Hi, I'm using Office 2003 and hoping for an answer. What I want to do is have either a cell or column highlight when another cell is chosen. For example...
June 16th, 2009 02:36 PM
by Luke M Go to last post
1 119
Autofilter query? by Me!
A colleague has a problem whereby when he colours selected rows when the Autofilter is on, and then removes the filter, not only his selected rows are...
June 16th, 2009 01:28 PM
by Bernie Deitrick Go to last post
1 170
Difference betwen Excel Date () Function and System Date by Khalil
I am confused to differnece between system date and excel Date () function. Please difference the following: 1... =Date(year, month, day) 2... Simple...
June 16th, 2009 01:10 PM
by Jacob Skaria Go to last post
2 153
Difference System date and Excel Date function by Khalil
Dear Experts: I am confused to differnece between system date and excel Date () function. Please difference the following: 1... =Date(year, month, day)
June 16th, 2009 11:23 AM
by David Biddulph Go to last post
2 128
Message box date format macro help by Aaron
Sub proving() Worksheets("Proving Equipment").Visible = True Sheets("Proving Equipment").Select If (n62 + 31) o62 Then MsgBox ("Proving Equipment...
June 16th, 2009 08:16 AM
by Aaron Go to last post
2 118
Message box date format macro help by Aaron
Sub proving() Worksheets("Proving Equipment").Visible = True Sheets("Proving Equipment").Select If (n62 + 31) o62 Then MsgBox ("Proving...
June 16th, 2009 07:17 AM
by FSt1 Go to last post
2 153
VLOOKUP: Wont return value by mind_killer
Hi, I have the opposite problem of some of those here. VLOOKUP is returning #N/A when it should be returning a value. The formula I am using is:...
June 16th, 2009 06:19 AM
by Archimedes' Lever Go to last post
6 188
summarising a list of data from numerous times down to once by Dubbo
Hi - The following is data I grab from my business system to tell me that I have parts in a location that still need to be counted in stock take - I spit a...
June 16th, 2009 05:41 AM
by T. Valko Go to last post
1 126
surya and siva by surya and siva[_2_]
hi i have a senario, please give me formula A B c d site patient querystatus querycount 209 517 answered ...
June 16th, 2009 05:31 AM
by surya and siva[_2_] Go to last post
0 112
Copy A1 into C1 if B1 contains data?? by Question, Mark
I want to copy whatever is in A1 into C1 if B1 has data. If b1 is blank then c1 should remain blank. The data in a1 or b1 could be either text or numbers....
June 16th, 2009 04:12 AM
by Fred Smith[_4_] Go to last post
3 155
How can I use a formula to return the first number in a range? by Husker87
I have a range A1:A10. I’m looking for a formula to put in B1 that will return the first number in my range A1:A10 when searching from top to bottom. ...
(Multi-page thread 1 2)
June 16th, 2009 03:26 AM
by RagDyeR Go to last post
14 309
Populating Data From Drop-Down Item by MR
Is there any way to click on an item in a drop-down box and have sets of information populate in another cell as a result of clicking on that item? i.e. I...
June 16th, 2009 03:14 AM
by T. Valko Go to last post
1 119
Formula For Finding a Quotation Mark In a String by Tiziano
I have a bunch of part numbers in Col. A formatted as Text. Some of these part numbers include a quotation mark (") to signify diameter in inches. For...
June 16th, 2009 02:05 AM
by T. Valko Go to last post
2 150
Post New Thread


Display Options
Showing threads 10081 to 10100 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 12:00 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.