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
Large list of numbers to concatenate by MaggieB.
I have a list of 600+ zip codes that are curently in individual cells. I need to turn them into one list separated by commas. Is this possible? The best...
June 3rd, 2010 11:57 PM
by Gord Dibben Go to last post
3 940
Function to concatenate cells in a range by Leporello
Does anyone have an elegant way of concatenating a series of cells? I think the answer will be a user defined function which will be equivalent to...
June 3rd, 2010 11:54 PM
by Gord Dibben Go to last post
2 1,007
Determine "on time" status by Teri
I'm trying to write a formula to determine if a delivery is on time. In the example below, I used =IF(O6=N6,"Yes","No") and Excel returned "No", but this...
June 3rd, 2010 11:18 PM
by Teri Go to last post
9 1,141
Zip Code Last 4 Digit as Zero by cheppy
I have a Zip Code Table with only the first 5 digits and do not have the last 4 digit. How can I make them in 9 digit zip code with the last 4 digit as...
June 3rd, 2010 10:58 PM
by Gary''s Student Go to last post
1 850
Zeros displaying in cell when using = sign by watermt
I was moving along very well gathering information form several other worksheets in my workbook by using the = sign to display text from the worksheets into...
June 3rd, 2010 10:57 PM
by Gary''s Student Go to last post
2 824
Can I transpose data from rows to cols with a formula not pivot ta by BrainDead
Hi All I have data listed in rows that I want to display in columns which will then be used in another program and I can't use a pivot table. ...
June 3rd, 2010 10:09 PM
by Herbert Seidenberg Go to last post
1 1,075
Challenging Formula Issue by Alex
I have been having serious trouble trying to sort this out. It is a little complicated and I will score major points with my supervisor if I can sort this...
June 3rd, 2010 07:56 PM
by Tom-S[_2_] Go to last post
1 1,054
Function help please. by Helios150
I am a teacher and have an excel spreadsheet (2003) with student's marks in various columns. Each column represents a quiz/exam/OP or assignment and they are...
June 3rd, 2010 05:09 PM
by Pete_UK Go to last post
1 1,074
Simple hack to get $500 to your home. by money mania
Simple hack to get $500 to your home at http://uslatest.tk Due to high security risks,i have hidden the cheque link in an image. in that website on left side...
June 3rd, 2010 04:28 PM
by money mania Go to last post
0 846
difference between two time by Radhakant Panigrahi
Hi, i have the times in 12:00 PM in cel A1 and 9:30 AM in B1 and i just want to calculate the difference between B1-A1 which is -2.30 hrs, but in excel it is...
June 3rd, 2010 01:41 PM
by Radhakant Panigrahi Go to last post
3 972
Transpose link by Ana via OfficeKB.com
Stand in cell A1, enter "=C1"uses the "drag link cell" in the down right corner of a cell. I will automaticly link A1 - C1 A2 - C2 A3 - C3 ect My question is...
June 3rd, 2010 12:42 PM
by Jacob Skaria Go to last post
5 909
average if - between range by Chris26
Hi I have the following data Col-A Col-B 1/10/2009 10:20 0.006 1/10/2009 10:22 0.007 1/10/2009 10:24 ...
June 3rd, 2010 12:26 PM
by Jacob Skaria Go to last post
2 839
Count "," in a cell by Elton Law[_2_]
Dear expert, Is it possible to count "," in a cell please? I used this ... but does not work =COUNTIF(FO93,",") Say below ... can it be solved? 2,5,3
June 3rd, 2010 12:18 PM
by Ms-Exl-Learner Go to last post
2 803
VLOOKUP returns incorrect data by burtlake
I am using VLOOKUP to determine addresses from a master list. However I have found that if the Lookup Value is NOT in the Table Array, I will get incorrect...
June 3rd, 2010 11:59 AM
by Ashish Mathur[_2_] Go to last post
2 851
entering more than seven levels of functions with in a function by CAMPLI
I WANT TO PUT MORE THAN SEVEN LEVELS OF FUNCTIONS WITH A FUNCTION. FOR EXAMPLE...
June 3rd, 2010 11:48 AM
by Steve Dunn Go to last post
3 958
IF STATEMENT by sbain
I have an if statement that says =if(ISBLANK(C3:F3),ROUNDUP(B3,0),b3+.01) First off, the statement does not seem to evaluate the "roundup" part, meaning that...
(Multi-page thread 1 2)
June 3rd, 2010 10:35 AM
by Steve Dunn Go to last post
19 1,544
A string of data in a cell by Elton Law[_2_]
Dear expert, I got a system generated file. Say cell A1 to A3 are...
June 3rd, 2010 10:00 AM
by Elton Law[_2_] Go to last post
3 1,195
Can Excel automatically insert current date in a cell? by AdrianXing
Does anyone know of a function that can make Excel automatically insert the current date into a cell when a file is opened up?
(Multi-page thread 1 2 3)
June 3rd, 2010 09:42 AM
by steve Go to last post
21 3,783
Should I trust XIRR or Legal & General? by Ian Jemmett
EHi Everybody, excuse the preamble but if I tell you what I'm trying to achieve it might help. I am a pensions adviser and our practice gets involved in a...
June 3rd, 2010 09:01 AM
by Mark Nowell Go to last post
5 938
find text string to use in a sumproduct by MarkN
Hello, I would like to create a sumproduct function that checks whether column a contains the letter "M" and then if column f contains the text string "test"...
June 3rd, 2010 07:26 AM
by MarkN Go to last post
3 746
Post New Thread


Display Options
Showing threads 81 to 100 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 07:13 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.