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
cell to have comma-delimited values based on text by Richard the Lion-Hearted
I have a table called "220_reference" with a column name "Part Number" having a sample value of below: 4047122(All Dash no.), 4057222(All Dash no.),...
March 22nd, 2010 09:20 PM
by JLatham Go to last post
8 106
How do I add up a range of times giving answer in hrs & mins >24h. by Richard T
I am trying to add up a range of times that will eventually be greater than 24hours, but I need to express this in hours and minutes. I then need to work out...
April 13th, 2005 04:10 PM
by RagDyeR Go to last post
2 99
Age using date formula by Richard St John Ambulance UK
. Reply (E-mail) Forward (E-mail) Subject: Age using date formula. From: "Richard - St John Ambulance UK" Sent: ...
July 21st, 2004 06:56 PM
by Richard Go to last post
2 91
Formulas by Richard Sheoo
Please can any one help me? I need to be able to work out a total price but the price will change as the quantity increases. For example 1 @ £1.99 5 @...
(Multi-page thread 1 2)
February 5th, 2007 08:43 PM
by Roger Govier Go to last post
15 99
Formulas by Richard Shaw
I am running Excell 2000 Version 9.9.3821 SR-1 on my Millenium system. I want to have the number in a given cell recorded automatically in another cell, if...
October 14th, 2003 06:13 PM
by David Hager Go to last post
2 84
Left function returning first word by Richard Ruda
We've done a search under help for a "left" function that will return the first word in a column (so theoretically, the funtion is searching for the first...
August 3rd, 2004 10:55 PM
by Richard Ruda Go to last post
4 289
Simple find with right function by Richard Ruda
We have a field of characters similar to: product/small/GW1400A-GAVE.jpg We have unsuccessfully tried to use the RIGHT AND FIND functions to find all...
(Multi-page thread 1 2)
November 2nd, 2005 09:06 PM
by DOR Go to last post
14 256
covert text to e-mail address by Richard Rosell
I am using Office XP. I wish to create a database of e-mail addresses in Excel. I began by copying the list of names from a company web site directory list. I...
August 9th, 2004 05:29 PM
by cmart02 Go to last post
2 99
XML date formatting by Richard Roche
Excel won't let me format a column w/ dates from XML. Any advice appreciated. Sample date: 2005-10-19T15:10:00.0000000-06:00 -- Richard
December 6th, 2005 07:49 PM
by Richard Roche Go to last post
0 81
Convert column data to semicolon delimited text string by Richard RE
Hi, I want to convert a column with let's say about 900 hundred rows with data (numbers) into a single string, where the rows data are semicolon delimited....
September 5th, 2006 03:03 PM
by David Billigmeier Go to last post
1 114
Problem with decimal format by Richard RE
Hi, We have problem with a spreadsheet where we use VBA to move inputed data in cells within a column to a row. The inputed data looks like, 0,3446325533953...
June 22nd, 2006 05:49 PM
by Richard RE Go to last post
2 84
moving column/cell data to rows/cells fails by Richard RE
Hi, We have problem with a spreadsheet where we use VBA (cell, text and csn command) to move inputed data in cells within a column to a row. The inputed data...
June 20th, 2006 06:05 AM
by Richard RE Go to last post
0 71
Lookup value that falls between two values in a range and then som by Richard Radcliffe
I have an array with 4 columns: A B C D 1 435 578 ID1 2 12 113 ID2 3 1478 1879 ID3 etc ...
April 20th, 2010 10:20 PM
by T. Valko Go to last post
2 168
search and export multiple records by Richard R
We have an Excel spreadsheet for all 1200 of our employees with name, department name, SSN and birthdate. I have added another field to sort by birthmonth...
January 17th, 2006 10:48 PM
by Dave Peterson Go to last post
3 58
Automatic filtering and coping result to a seperate sheet by Richard P
Need some help with this,, I am creating an estimation template wher I have a parts list in one sheet. If I go to that sheet and enter 1 or grater in the qty...
April 23rd, 2006 07:28 PM
by Richard P Go to last post
2 101
Not listing more than a range of rows by Richard P
I have two sheets, one has my equipment database and the other is the results "Quote sheet". in my Quote sheet I am using the: =IF(ROW()-1MAX('Equip...
September 18th, 2006 12:43 AM
by Richard P Go to last post
2 45
Linked workbooks by Richard O. Neville
If you just want them to see the data, do the following: use Ctrl+A to select the entire page in each sheet tab. Then Ctrl+C to copy it, and Ctrl+V to paste it...
February 12th, 2004 08:19 PM
by ERB Go to last post
1 319
search a cell against a list of values and return the value by Richard Norris
I'm trying to find a function or method of looking at the content of a cell and if a match is found against a list then return that value. eg. From Column A,...
August 23rd, 2004 07:12 PM
by hgrove Go to last post
2 275
loosing test fomat after using replace command by Richard Miller
we are importing payroll information which includes a SS number formatted with the dashes (xxx-xx-xxxx). The infomation is used to upload to the state which...
October 27th, 2005 03:46 PM
by Dave Peterson Go to last post
1 78
add vs. replace data when merging workbooks by Richard Meister
I am merging several workbooks into one shared master and want to ADD updated data versus REPLACE the data when doing subsequent searches. Does anyone know...
August 14th, 2006 03:19 PM
by Richard Meister Go to last post
0 41
Post New Thread


Display Options
Showing threads 20161 to 20180 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:25 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.