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
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 456
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 419
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 391
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 373
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 457
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 552
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 599
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 342
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 425
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 347
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 361
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 328
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 333
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 425
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 831
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 601
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 2,318
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 390
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 333
Copying daily data from one tab to a weekly summary table by Dam
I have been working on this for a little while now and can't seem to grasp the right formula to use. I have columns of data sorted by name to be tracked...
June 3rd, 2010 06:54 AM
by Jacob Skaria Go to last post
6 521
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 03:00 PM.


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