I need alot more help...

TiggerToo

Board Regular
Joined
Feb 26, 2002
Messages
158
In block c6 to c9 I have one date,
In block e6 to e9 the total is 8.
In block f6 to f9 I am looking for one of three codes.
What formula do you use when you need to look at c6 to c9 for the date.
look at e6 to e9 for the hours to total 8.
look for one of the three codes in the same blocks, for only one block.

I tried countif and it did not help. Anymore ideas.
I can e-mail a part copy of the project I am working on, to see if you all can improve on my personal project.
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
On 2002-03-08 11:41, TiggerToo wrote:
In block c6 to c9 I have one date,
In block e6 to e9 the total is 8.
In block f6 to f9 I am looking for one of three codes.
What formula do you use when you need to look at c6 to c9 for the date.
look at e6 to e9 for the hours to total 8.
look for one of the three codes in the same blocks, for only one block.

I tried countif and it did not help. Anymore ideas.
I can e-mail a part copy of the project I am working on, to see if you all can improve on my personal project.
Are you looking to determine if C6 is a certain data AND E6 is 8 AND F6 is one of three codes? And then do the same for row 7, 8 and 9?
 
Upvote 0
Barry,
I need all the help I can get with this project I took on myself, because I did not know if the timekeepers would keep my time straight. So I started making a form that I thought would be simple, but NOT.
If you or anyone would be so kind and look at my past posting, I would deeply be app...
or if you want me to e-mail you a copy. I could
Thank alot,
Walter
 
Upvote 0
On 2002-03-08 18:33, TiggerToo wrote:
Barry,
I need all the help I can get with this project I took on myself, because I did not know if the timekeepers would keep my time straight. So I started making a form that I thought would be simple, but NOT.
If you or anyone would be so kind and look at my past posting, I would deeply be app...
or if you want me to e-mail you a copy. I could
Thank alot,
Walter

Walter, go ahead and e-mail me a copy of your spreadsheet. Please include a concise description of your requirements.

Regards,
 
Upvote 0

Forum statistics

Threads
1,213,506
Messages
6,114,024
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top