Posts by 2rrs

• Dispaly Sum if a cell is filled in

Re: Dispaly Sum if a cell is filled in

Or something like this:

=IF(A1="","",(TODAY()-A1)/365.26)

• Excel 97 Editing & removal of leading spaces

give data&gt;text to columns a try. this usually works for me

• Showing Record count when filtering

If the formula solution does not suit; you can go to tools&gt;options&gt;calculation and check the manual box.
This will display the results in the status bar.

• Showing Record count when filtering

Try this:

SUBTOTAL(3,A1:A500)

• Printing : Excel Spreadsheet – Printing format

Custom format; 00000

• [Solved] Formulas : Sequentially number selected items in a

Here is a rather simple method:

Filter the list on FG
On the 1st FG item; chg to FG 0001
Drag and fill down the filtered list.
Unfilter the list and you will have a sequentialy numbered list

• VBA : How to link data from 1 worksheet to the other?

In sheet 2

Select the cell where you want the data to appear.

Now select sheet 1

Now select the cell in sheet 1 that you want to appear in sheet 2

Hit enter.

• [Solved] day information

Hi ecggt,
Sorry but I don't understand what you mean by "no frame".
I tested it and Brandtrock's formula with a series of 24 different dates and both returned the same results.
I did have to add "Friday and Saturday" to Brandtrock's formula which I copied and pasted from the post.

• [Solved] day information

Or maybe this;

=TEXT(A1,"dddd")
fill down

Tools
options
view

• [Solved] Formulas: Dates

Try this:
Assumes due date is in col C2:C100
and # of days in col D2:D100

In a cell off to the side of your data; say H1, enter =TODAY()

In D2 enter: C2-\$H\$1 and copy down; this returns the number of days between the current date and the date in col C

Conditional format col D for &gt;14 days

2rrs

• [Solved] Formulas: FVSCHEDULE nested DATE Formula (Hints Wel

Give this a try:

In B54 enter =SUM(OFFSET(B46,0,0):OFFSET(B46,-12,0)) Drag across to I54

In B55 enter =SUM(OFFSET(B46,0,0):OFFSET(B46,-24,0)) Drag across to I55

In B56 enter =SUM(OFFSET(B46,0,0):OFFSET(B46,-36,0)) Drag across to I56

[quote]Originally posted by dbin78
Thank You,

What would it be to use a date in a cell?
If i enter any given date and want to add three months.
Cell A1 = 02/02/03
Cell A2 = A1+3 months????

Thanks [/quote

Try this:

=EDATE(A1,3)

• [Solved] Formulas: Ongoing % formula

Give this a try:

=AVERAGE(OFFSET(B9,0,0,1,MONTH(NOW())))

2rrs

• Summarising information in XL

Hi excelnewbie,

I also thought of a pivot table but did not think that the layout would support it.

Two things you mentioned suggest a more basic solution may be considered.
a) You have a large spreadsheet; this would make the task of changing the layout to support use of a pivot table difficult;
b) You state that the purpose for the summary is to print a sheet to put in a folder.

The sample layout that you provided shows data for two stores; if you want to print the data for one store only; you could select all data for 'store number 5211"; then go to file, print, and check "selection".then OK.
This will print only store 5211 data.
Do this for each 'store number"

I hope I did not misunderstand the purpose of your post.

2rrs

• [Solved] formulae that can be used to calculate YTD

Hi Neale,

It didn't take long for me to run into trouble!

I got as far as drawing the combo box; then found that my control tab was "gray", I tried to figure it out with no luck.

I did find this on Google MS excell public forum:

"Quote"
Ken Anderson wrote: &gt; Hi, I am trying to create a drop down combo box in excel &gt; 2000. I create the box and then right click over the top &gt; of it and select 'Format Control'. At that point I'm &gt; suppose to be able to go to the 'Control' tab and give it &gt; the input range. However, the control tab isn't &gt; there. 'Size, Protection, Properties and Web' tabs are &gt; there, but no Control tab. If I go to a spreadsheet that &gt; already has a drop down box created on it, and i right &gt; click and goto the Format Control..it has a Control tab. &gt; But there isn't one when I try to create it from scratch.

"Response"
The existing combo boxes are from the Forms toolbar, and you're using the combo box from the Control Toolbox. To set the properties for your combo box, select the combo box, and click the Properties button on the control toolbox. You can set the ListFillRange (like Input range), LinkedCell, and ListRows properties.
-- Debra Dalgleish Excel FAQ, Tips & Book List
___________________________________

I attempted to follow the directions, but I am lost.