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 » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 42
Search took 0.29 seconds.
Search: Posts made by: Tacrier
Forum: New Users June 1st, 2010, 08:51 PM Posted to microsoft.public.excel.newusers
Replies: 1
Views: 2,154
Posted By Tacrier
#VALUE! result when using defined name in formula

I am learning how to name cells and use these names.

I tried to name a cell in my Summary sheet using the sum of cells in my
Detail sheet. When I press enter, the cell returns a #VALUE! What am i...
Forum: General Discussion May 6th, 2010, 06:06 PM Posted to microsoft.public.excel.misc
Replies: 19
Views: 423
Posted By Tacrier
Adding up hours and minutes

Thank you David (sorry for the late reply!)

:)

"David Biddulph" wrote:

It won't be 10.30, it will be 10:30. There is a difference between a colon
and a decimal point.
If you want to turn...
Forum: Worksheet Functions May 6th, 2010, 05:58 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 0
Views: 115
Posted By Tacrier
Calc staff vacation time based on more than 1 criteria

I would like to calculate on a daily basis, accumulated vacation time based
on the following criteria:

Total daily hours (work and leave taken)
Hours must fall on a week day
Entitlement hours from...
Forum: General Discussion February 10th, 2010, 08:23 PM Posted to microsoft.public.excel.misc
Replies: 19
Views: 423
Posted By Tacrier
Adding up hours and minutes

I have been reading the answers to hour/minute type questions but can't seem
to find the answer I need...

I am trying to calculate total hours worked in during a night shift like this:

A1 =...
Forum: General Discussion November 18th, 2009, 07:12 PM Posted to microsoft.public.excel.misc
Replies: 1
Views: 89
Posted By Tacrier
subtotal data from 2 columns into 3rd column

Is there a formula I can use to subtotal column data instead of using the
subtotal feature?

When I try using the subtotal feature it puts the subtotal at the bottom of
data. I would like to...
Forum: General Discussion November 17th, 2009, 10:22 PM Posted to microsoft.public.excel.misc
Replies: 1
Views: 114
Posted By Tacrier
Auto sum 2 adjacent row data into 3rd row?

I have a list of people's names in column C and cost data for each person in
column M and N.

Is there was to provide a subtotal of all cost data for each person in
Column O?

i.e.:

row 1 Smith,...
Forum: General Discussion February 18th, 2009, 11:29 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 68
Posted By Tacrier
Cannot change paper size

Hi there!

I am trying to change the worksheet paper size from letter to legal but the
page setup menu has the paper size drop down menu de-selected. What's going
on?

:(

Trina
Forum: General Discussion January 6th, 2009, 09:55 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 68
Posted By Tacrier
VLOOKUP works for some cells but not all Help!

Awesome! That worked!

Thank you. :)

"Bob Umlas, Excel MVP" wrote:

Most likely the value you're looking up has many trailing spaces -- if you
highlight the reference in the VLOOKUP formula &...
Forum: General Discussion January 6th, 2009, 06:50 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 68
Posted By Tacrier
VLOOKUP works for some cells but not all Help!

On a quarterly basis I import information from another program into excel so
that I can format the information into a specific format.

When the info. is first imported it is all in column A so I...
Forum: General Discussion December 17th, 2008, 07:02 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 129
Posted By Tacrier
autofill colour based on date entered

It made all of the empty cells grey (yay!) and all of the entered cells blue
(boo) lol

Don't know what else to do except manually colour the cells? :(



"Sheeloo" wrote:

Try
Forum: General Discussion December 17th, 2008, 05:48 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 129
Posted By Tacrier
autofill colour based on date entered

Sorry for not replying right away,

I tried the conditional formatting you had suggested, I modified it (or
tried to) because I had put the wrong column labels when describing my
spreadsheet. Here...
Forum: General Discussion December 10th, 2008, 12:38 AM Posted to microsoft.public.excel.misc
Replies: 4
Views: 129
Posted By Tacrier
autofill colour based on date entered

Hi there!

I had posted this question last week and didn't get far without the analysis
add-in. I got it now but am missing the instructions on the howto? :P

What I would like to do is colour code...
Forum: General Discussion December 9th, 2008, 10:43 PM Posted to microsoft.public.excel.misc
Replies: 9
Views: 198
Posted By Tacrier
autofill colour based on date entry

I now have the analysis toolpak, how do i go about using the networkdays
formula in the conditional formatting?


"Tacrier" wrote:

I do not have the original installation CD :(

Will check...
Forum: General Discussion December 8th, 2008, 07:29 PM Posted to microsoft.public.excel.misc
Replies: 9
Views: 198
Posted By Tacrier
autofill colour based on date entry

I do not have the original installation CD :(

Will check back with all of your suggestions once I am able to install the
ATP.

Thanks again

Trina C

"Gord Dibben" wrote:
Forum: General Discussion December 8th, 2008, 06:26 PM Posted to microsoft.public.excel.misc
Replies: 9
Views: 198
Posted By Tacrier
autofill colour based on date entry

I tried to activate it through the toolsadd-insATP and a message appears
indicating a CD-ROM needs to be inserted. Still no luck. :(

"Gord Dibben" wrote:

The ATP cannot be downloaded.

It...
Forum: General Discussion December 5th, 2008, 12:04 AM Posted to microsoft.public.excel.misc
Replies: 9
Views: 198
Posted By Tacrier
autofill colour based on date entry

Unfortunately I am using Excel 2000 and in the process of getting my tech
guys to buy the 2007 office suite for my department.

Any other suggestions?

"dlw" wrote:

you would use the conditional...
Forum: General Discussion December 4th, 2008, 11:24 PM Posted to microsoft.public.excel.misc
Replies: 9
Views: 198
Posted By Tacrier
autofill colour based on date entry

I have a spreadsheet to record when monthly duty reports are received by each
employee and reviewed by mgmt.

Column A1:A200 Employee Name
Column B1:B200 Date Received in April
Column C1:C200 Date...
Forum: General Discussion October 27th, 2008, 10:33 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 73
Posted By Tacrier
Subtotal at the top instead of the bottom?

Sorry, I missed a couple words in my question, please disregard previous post
and have a look at this one:

Is there a way to subtotal B:C columns into column D instead of at an
inserted row at...
Forum: General Discussion October 27th, 2008, 09:58 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 73
Posted By Tacrier
Subtotal at the top instead of the bottom?

Is there a way to subtotal B:C columns into column D instead of at an
inserted row at the bottom of change in Column A?

I would like to have the subtotal show in column at each change in column...
Forum: General Discussion October 26th, 2008, 09:18 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 78
Posted By Tacrier
SUMIF based on duplicates?

Your Data Filter/SUMIF combo worked in a matter of minutes (I would say
seconds, but it took me two tries to figure it out)

Again, Thank you!! :)

"Sheeloo" wrote:

Why are you still working?...
Forum: General Discussion October 25th, 2008, 03:40 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 78
Posted By Tacrier
SUMIF based on duplicates?

Good Question. lol

Thankyou for your speedy reply, I will try this formula out when I get to my
office this evening or tomorrow. Update on results coming soon!

"Sheeloo" wrote:

Why are you...
Forum: General Discussion October 24th, 2008, 11:39 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 78
Posted By Tacrier
SUMIF based on duplicates?

Hi there,

I have 3 columns like this:

A B C
200.00 998
500.00 999
505.00 ...
Forum: General Discussion October 24th, 2008, 11:24 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 101
Posted By Tacrier
Find partial match from column A,B and fill partial match in C

Thank you that worked great!! :)

"Sheeloo" wrote:

Column with Name (your col J on Vendors) has to be on the right of Col H
(which has the combined data). To get this copy Col H and PASTE
...
Forum: General Discussion October 22nd, 2008, 06:26 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 101
Posted By Tacrier
Find partial match from column A,B and fill partial match in C

I am having trouble with the formula you suggested. :(

To make it a little easier, I have reformatted my information so that sheet
1 called 'Working Copy', and sheet 2 called 'Vendors' both have...
Forum: General Discussion October 17th, 2008, 10:10 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 101
Posted By Tacrier
Find partial match from column A,B and fill partial match in C?

Hi there!

I have Spreadsheet 1 and Spreadsheet 2 with the same information but
Spreadsheet 2 is missing the 'Vendor Name' information that I need.
Spreadsheet 1 may also not contain the same...
Showing results 1 to 25 of 42

 
Forum Jump

All times are GMT +1. The time now is 03:51 PM.


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