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
most used value by Haralambus
hi, I have data in 1300 rows and 8 columns (all numbers). How can I filter out most used x values? thanks
February 24th, 2009 09:18 AM
by Tom[_46_] Go to last post
3 74
Convert Turn Rate to Weekly Supply by Joe
A1 = Monthly Inventory Value of 12 A2 = Monthly Cost of Goods Sold of 3 A3 = =A1*12/A2 It would be helpful to have a calculation that could arrive at the...
(Multi-page thread 1 2)
February 24th, 2009 09:14 AM
by Bob Phillips[_2_] Go to last post
13 181
Applying Max Conditonal Formatting to an entire row when condition by SunshineinFt.Myers[_2_]
I want to change the entire row color when one cell is the max out of the range. Ex: A1, B1, C1, with the the Max being in cell D1?
February 24th, 2009 06:56 AM
by Shane Devenshire[_3_] Go to last post
2 114
I need a fx for counting numbers between numbers (between 18 - 59 by Jen
I am trying to have excel count numbers that fall between certain numbers. I.e. all numbers in column B that range from 18-59 (that include the #18 and #...
February 24th, 2009 06:54 AM
by Shane Devenshire[_3_] Go to last post
2 92
fx for vacation by Ray
I need to compute the vacation earned by an employee. Each employee earns 3.08 hrs every two weeks. How would write that as a formula.
February 24th, 2009 06:49 AM
by Shane Devenshire[_3_] Go to last post
2 111
Making a budget by ren1821
I need to make a budget to show 10 years from now. Does anyone know what formulas that entails?
February 24th, 2009 06:48 AM
by ren1821 Go to last post
2 126
Conditional formatting Max to a entire row A1:D1 with E1 being Ma by SunshineinFt.Myers[_2_]
Hi again. Example: Max numbers are in ending column say E1, E2, ect... but I do have numbers in all other cells that are higher numbers then what is in cell...
February 24th, 2009 06:38 AM
by Shane Devenshire[_3_] Go to last post
2 102
Data Analysis Tool by Cesar
Hello everyone, I frequently use the Data Analysis Tool, particularly the Histograms, I was wondering if there is a way to write a macro that does this for...
February 24th, 2009 05:44 AM
by Mike Middleton Go to last post
5 118
VLOOKUP by Workbook
=VLOOKUP(B7,C4:D33,2,0), how can I modify this so that it works when B7 is on Sheet 1 but C4:D33 are on Sheet 2?
February 24th, 2009 04:35 AM
by Workbook Go to last post
4 93
Applying Conditional Formatting to a Max number in range by SunshineinFt.Myers
I highlight the cells: Ex 1, 5, and 10 go conditional formatting and I am not sure how to specify that I want the number 10 which is the max number in the...
February 24th, 2009 03:43 AM
by T. Valko Go to last post
5 108
Drop down list from another worksheet by hcronrath
Hi, I have two worksheets, and I want to create a drop down list on the second sheet from a list of names on the first sheet. Does anyone know how to do...
February 24th, 2009 02:59 AM
by T. Valko Go to last post
2 95
Using list choices to use as headers by Obrien21
I want to set a summary page of data collected per part numbers. I want to add alike cells that have the same part number. The user chooses a part number...
February 24th, 2009 02:34 AM
by Obrien21 Go to last post
3 80
Removing first 10 characters of text by Scott
Hello, I have a list of 1,000 rows of data and I want to remove the first 10 characters from each cell. I can't use the =RIGHT function because each cell...
February 24th, 2009 01:59 AM
by Shane Devenshire[_3_] Go to last post
3 71
How could I return to the first row after I finish the last entry? by Grace
IF I have a big long worksheet data to enter, how could I return to the first row when I finish the last entry at the bottom of the worksheet? Thanking you...
(Multi-page thread 1 2)
February 24th, 2009 12:39 AM
by Grace Go to last post
11 183
Sum of two offset cells by Craig
Hi, I'm having difficulty with this function. =sum(offset(Sheet6!$B$47,(rows($1:1)-1)*47,0))+(offset(Sheet3!$B$47,rows($1:1)-1)*47,0))) Can you tell me what...
February 24th, 2009 12:19 AM
by Roger Govier[_3_] Go to last post
4 96
gain-loss by gma
A1 B1 C1 D1 E1 F1 G1 100 5.00% 95 5 95 5 100% i need G1 to increase as E1 increases. the way it works now if E1 increases then G1 decreases. the way the...
February 23rd, 2009 11:07 PM
by gma Go to last post
5 93
Tabbing Question by Joann
I have a worksheet that I am putting together & when I tab through it, I only want it to tab to the cells that I need to be completed by others (as opposed...
February 23rd, 2009 11:01 PM
by Shane Devenshire[_3_] Go to last post
5 144
my vlookup path changes when I open the file by AliGoLightly
I have a VLOOKUP in workbook 'Report' which looks for data in workbook 'Data'. both workbooks are stored in a common network drive \\office\reports\ the...
February 23rd, 2009 10:52 PM
by Shane Devenshire[_3_] Go to last post
1 106
Conditional Format Font Color for more than 3 conditions by abusymomforever
A B J K 7 Date Store # Date Store # 8 9 01/01/2009 1122 10 ...
February 23rd, 2009 10:48 PM
by abusymomforever Go to last post
3 102
VBA question by ub
Hi I have a workbook in which I have written VBA code. I want to hide this from the User. Can you please advise, how can I do this. Thanks
February 23rd, 2009 10:43 PM
by Bob Umlas[_3_] Go to last post
1 90
Post New Thread


Display Options
Showing threads 14001 to 14020 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:24 PM.


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