|
|
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
|
|
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...
( 1 2)
|
|
13 |
181 |
|
|
|
|
2 |
114 |
|
|
|
|
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.
|
|
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
|
2 |
126 |
|
|
|
|
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...
|
|
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
|
4 |
93 |
|
|
|
February 24th, 2009 03:43 AM
by T. Valko
|
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
|
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
|
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...
|
|
3 |
71 |
|
|
|
February 24th, 2009 12:39 AM
by Grace
|
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...
|
|
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
|
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...
|
|
5 |
144 |
|
|
|
|
1 |
106 |
|
|
|
|
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
|
|
1 |
90 |