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
formatting cells by pat67
Hi, I am trying to format cells that contain dollars in millions and make it decimal. i.e $1,500,000 would show $1.5 and the head of the table would say...
March 16th, 2010 09:06 PM
by Gord Dibben Go to last post
1 109
vlookup(date, range,3) by David
Hello Group, I am doing a vlookup on a date, I will take the closest date, so have not used the last parameter. It returns the last date in the list always....
March 16th, 2010 09:06 PM
by T. Valko Go to last post
3 111
Excel 2007 - worksheets macro by version83
Hello. I am using excel 2007, and i am still a beginner, so i would like to ask for your help for making the following: a macro which adds a list with the...
March 16th, 2010 08:56 PM
by Gord Dibben Go to last post
1 128
Using spreadsheet to fill in forms by Nicci
We need to create a form of an invoice in a very specific format (determined by an international shipping company). We will have several items which will...
March 16th, 2010 08:48 PM
by Eva Go to last post
2 111
Vlookup and Hlookup by cadustin
I am trying to figure out something that may be very simple, but I am not getting it. I want Vlookup to look at two things to bring back an answer. Here is...
March 16th, 2010 08:39 PM
by cadustin Go to last post
4 123
Help: vlookup from multiple sheets and spreadhseets by Mr Fujisawa[_2_]
I currently have a spreadhseet which lists frauds on cards (card number, date, description etc), 1 row for each card with 12 sheets, 1 sheet for each month...
March 16th, 2010 08:11 PM
by Herbert Seidenberg Go to last post
1 120
auto populate unused rows from workbook to workbook by JG
Please Help. I can't seem to get the data entered on one workbook to enter on another workbook without over writing. I've set up a master seed file where...
March 16th, 2010 08:06 PM
by JLatham Go to last post
1 117
sorting grouped cells by D$
Is it possible to sort grouped cells? I have a sheet designed for volleyball stats where total stats show when all the individual game cells are collapsed,...
March 16th, 2010 07:47 PM
by Bernie Deitrick Go to last post
1 135
Excel Sorting by Lori
I did not create the worksheet, but need to sort the data. Get a message saying " This operation requires the merged cells to be identically sized" An...
March 16th, 2010 06:35 PM
by Gary Brown[_5_] Go to last post
2 103
Looking for a Function? similar to LEFT by KatieR
I have a list of org unit names that are always preceded by a 3 digit number. How can I just show the text and not the numbers? Example: 001 Org Unit Name...
March 16th, 2010 06:31 PM
by Harlan Grove[_2_] Go to last post
5 104
calculating % of a monthly budget on a daily basis by DZ
I have a monthly budget figure, and I'm trying to use a formula to show what % of budget I'm at on a daily basis. For instance, my budget for the month is...
March 16th, 2010 05:26 PM
by rzink Go to last post
3 128
Copying values/formulas from only visable lines when filters are o by excelchallenged
I have huge spreadsheet with dozens of columns, and filters are on most columns. In my last column, I want to systematically post the results only of...
March 16th, 2010 05:08 PM
by excelchallenged Go to last post
0 95
If function and a range by mrsatroy
I have the following function and it is only half working for me as my arguements seem to contradict one another as I want to see if my number falls within a...
March 16th, 2010 05:07 PM
by Bob Phillips[_3_] Go to last post
4 124
hiding/unhiding rows by Art
I know I can create a macro that allows a user to, say, press CTRL-H and the first three rows of my spreadsheet will become hidden. (Some users prefer having...
March 16th, 2010 05:00 PM
by Paul C Go to last post
1 110
Creating a Macro to autofill and save by LauraB
Hi, I am trying to create a macro that will complete the following. Autofill column K with sequential numbers starting from cell K2 with 1 to however many...
March 16th, 2010 04:46 PM
by Gord Dibben Go to last post
9 152
Need help with formulae comparing date-based numbers by Dataslinger
I'm trying to write a Excel formula that enters an integer value for a cell, the value representing an age in days. To get this value, I'm comparing values...
March 16th, 2010 04:21 PM
by T. Valko Go to last post
2 101
How do I turn off R1C1 reference type in Excel 2007? by Mag
In Excel 2003 you turn off R1C1 reference type by unchecking "R1C1 reference type" under Settings in the menu Tools - Alternative - General. However, I'm not...
March 16th, 2010 04:18 PM
by Bob Phillips[_3_] Go to last post
3 146
If Vlookup is error ( #NA) by Steve
I have this formula =IF(VLOOKUP(RU!C3,data!$E$3:$R$16,2,FALSE)0,(VLOOKUP(RU!C3,data!$E$3:$R$16,2,FALSE)),"") that is producing #NA if it doesn't find C3. I...
March 16th, 2010 04:07 PM
by T. Valko Go to last post
5 176
Setting up a formula (when F211,000)=$25 by Hawkeye
Setting up formulas for my business on Excel 2007. I have a column for lot sizes of properties. I need to have a second column that contains a formula that...
March 16th, 2010 03:53 PM
by trip_to_tokyo[_3_] Go to last post
3 78
Delete Rows using If and Wildcard by Max2073
I'm trying to delete all rows that DO NOT contain the text "ENTER" in column F. I have tried a few different methods based upon research from this site, but...
March 16th, 2010 03:24 PM
by Don Guillett[_2_] Go to last post
2 101
Post New Thread


Display Options
Showing threads 2081 to 2100 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:32 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.