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
combining dates and text in a cell by Cecilia
Hello-- I had a column with dates and another with text labels. I'd like to combine these and tried using this formula: =D6&" "&I6 D6 = 7/4/2009 I6 =...
March 19th, 2010 07:22 PM
by JLatham Go to last post
1 65
a Counting question by cinnie
hi to all I'm sure this is easy, but I'm new to Excel. I need a function that will COUNT all the numbers in a range (B5:B1525) equal to or greater than the...
March 19th, 2010 07:08 PM
by cinnie Go to last post
4 87
Lookup 2nd & last match with two conditions by Billy Leung[_2_]
Hello, I've a table below, I would like to setup a query which could return a value showing the 2nd match and last match in the next column. Thank in...
March 19th, 2010 06:34 PM
by T. Valko Go to last post
6 81
formula required by Sohail khan
Dera plz solve my problem, i m working in a bank my query is that Today is 9-mar-10 my ending balance is 10,0000.00 in sheet 1 column A2 . and this balance...
March 19th, 2010 06:11 PM
by Sohail khan Go to last post
0 76
Auto Filter - It's broken! Help! (Office '03) by Elgee
So - I can't seem to find anyone who has ever seen this issue - I have a generic worksheet - standard columns / rows - all related to various projects /...
March 19th, 2010 06:01 PM
by Elgee Go to last post
2 67
how do i create a formula to give a workday date? by jjhacke
I am trying to set up a worksheet the gives me a date during the work week that is 5 work days, 10 workdays, etc from the date that is entered. I also want...
March 19th, 2010 05:18 PM
by Ron Rosenfeld Go to last post
2 85
Messy Formula needs clean up help! by Danny Boy
The Formula below works, but feels quite sloppy, and I'm sure it can be accomplished in a much cleaner fashion. In addition, I attempted to add 1 more...
March 19th, 2010 04:24 PM
by Gord Dibben Go to last post
7 59
Extracting the last word from a string. by Ciarán
I have a list in excel like the one below. The filename is always after the last "/". What formula can I use to extract the filename? The number of instances...
March 19th, 2010 03:21 PM
by Teethless mama Go to last post
2 108
Two digit number with one decimal, or three digit number by Cass1930
I would like to have one decimal point in a number, unless the number is 100 in order to fit the columns in a table. So, three digits for whatever number I...
March 19th, 2010 03:18 PM
by Brad E. Go to last post
2 110
How to check if the values in a range of cells are greater than 0 by DP
Basically I want to check like IF(B3:B5 0,B1), if any of the values in B3 to B5 cells are greater than 0 then I take the value from the cell B1. How to do...
March 19th, 2010 02:31 PM
by Teethless mama Go to last post
3 81
Macros by Debbie
I'm new at running macros and I currently use the "record macro" button. I need to run a macro that recognizes "only populated data" in the columns so I can...
March 19th, 2010 02:25 PM
by Debbie Go to last post
2 76
Convert Array Formulas to Regular Formulas by Domenick
I have a workbook that is linked to a query from another (legacy) application. I have formulas that do further calculations with the query results....
March 19th, 2010 02:23 PM
by Domenick Go to last post
4 83
What caused my paste function not to work? by EXCEL USER
Even I checked the box under tools/edit/show paste button, I can not copy and paste from one excel workbook or file to another. How can I make the paste...
March 19th, 2010 11:55 AM
by PhilUK[_2_] Go to last post
2 90
Addition to a working formula by Scoober
I have this formula and it works fine. =IF(OR(S140="No",S140="0"),"",G140*X140) This is placed in cell p159 I now need to add the exact same information as...
March 19th, 2010 10:53 AM
by Zoltan Go to last post
1 93
Workday function not working by Cam
Hello, Why does it returns "#NAME?" when I use =WORKDAY function in Excel 2003? My formula is =WORKDAY(D4,-B1,Holiday!A2:E109) where D4 is a date and B1 is...
March 19th, 2010 10:51 AM
by Shaz[_2_] Go to last post
6 102
Electricity Bill Sheet by XKruodo
Hi, I posted a similar question 2 days back but seems like i was not clear enough with the question. The following table contains UNITS of electricity and...
March 19th, 2010 07:22 AM
by XKruodo Go to last post
6 69
IF statement based on True/False that activates a certain list box by rittzy
I've been asked to create a formula that will react to either "yes" or "no" entered into a cell which will show options in another cell based on a certain...
March 19th, 2010 07:01 AM
by Jacob Skaria Go to last post
1 77
paste values Excel 2007 by Diamond
Is there a way to setup a hot key to paste values in Excel 2007? Also, is there a way to change the icon buttons? Thx
March 19th, 2010 06:12 AM
by Matt Geare[_2_] Go to last post
2 83
Conditional Formatting with 3 Criteria Options by Nickle
I would like a Cell's Text to turn green if A1=B1, but turn red if A1B1, and no formatting if B1 is blank. What is the best way to go about this? I have...
March 19th, 2010 05:57 AM
by David Biddulph Go to last post
5 88
VLOOKUP with HLOOKUP by XKruodo
Hi, I thought this was simple and i could google it. but could not find a solution. Age 3 ( premium per years) 5 ( premium per year) ...
March 19th, 2010 04:41 AM
by XKruodo Go to last post
2 84
Post New Thread


Display Options
Showing threads 1981 to 2000 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 08:44 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.