# Search:

Type: Posts; User: musical1; Keyword(s):

Page 1 of 9 1

1. ## Thread: Excel Multiple IF logic scenario.

by musical1
Replies
8
Views
114

### Thank Maud - That was exactly what I was looking...

Thank Maud - That was exactly what I was looking for.
I came close a couple of times. My downfall was the P3<>"" segment. It created an air leak.

A couple of things happened that I had to fix....
2. ## Thread: Excel Multiple IF logic scenario.

by musical1
Replies
8
Views
114

### Excel Multiple IF logic scenario.

I have the following logic for which I have been valiantly attempting an IF statement for. As I have been unsuccessful - I am here.

Cell AN3 has a value of "On-going" or "Completed"
IF...
3. ## Thread: Custom formatting assistance

by musical1
Replies
9
Views
2,103

### RG - That was amazing! I love macros, but I'm...

RG - That was amazing! I love macros, but I'm very weak in that area of EXCEL.
That was so fun that I was opening my old data sheets and converting them!
4. ## Thread: Custom formatting assistance

by musical1
Replies
9
Views
2,103

### Beautiful! While I find Zeddy's formula easier...

Beautiful! While I find Zeddy's formula easier to addapt, I SO appreciate the date format approach... gives me future ideas.
5. ## Thread: Custom formatting assistance

by musical1
Replies
9
Views
2,103

### Wow, that was short and sweet! Thank you!

Wow, that was short and sweet!

Thank you!
6. ## Thread: Custom formatting assistance

by musical1
Replies
9
Views
2,103

### Custom formatting assistance

My spreadsheet contains data that was extracted from BOXI.
The dates are currently in the following character format: 20110805
Those numbers represent August 5, 2011.

My goal is to perform...
7. ## Thread: Sum for multiple Conditions; EXCEL 2003

by musical1
Replies
4
Views
2,473

### Thank you! I had danced around so many similar...

Thank you! I had danced around so many similar attempts, but I was trying to make it more difficult than it was.

Merci,
Jody
8. ## Thread: Sum for multiple Conditions; EXCEL 2003

by musical1
Replies
4
Views
2,473

### Sum for multiple Conditions; EXCEL 2003

Solution to be on Metrics tab, cel L4
Solution should be: 119 (The sum of 33 cells)
9. ## Thread: Sum for multiple Conditions; EXCEL 2003

by musical1
Replies
4
Views
2,473

### Sum for multiple Conditions; EXCEL 2003

I used this formula to return the number of times that "Monika" appeared for a given date range.

A4 contains my...
10. ## Thread: Pivot/Chart: sorting data

by musical1
Replies
6
Views
3,232

### Steve, this is the approach I was working on when...

Steve, this is the approach I was working on when your post came though... though I was considerably slower at the coding.

tfspry, this nailed the true essence of what I was wanting to achieve!...
11. ## Thread: Pivot/Chart: sorting data

by musical1
Replies
6
Views
3,232

### Pivot/Chart: sorting data

I have a bunch of data that I have collected for a MS office upgrade and I'm trying to sort the data.

I feel as though I'm missing something simple, but I'm just not seeing it.

Attached...
12. ## Thread: Calculating a Due Date with criteria

by musical1
Replies
2
Views
564

### Barron, That is sweet! Perfect, TY

Barron, That is sweet!

Perfect, TY
13. ## Thread: Calculating a Due Date with criteria

by musical1
Replies
2
Views
564

### Goal: Create a list of contracts and due dates...

Goal:
Create a list of contracts and due dates for annual maintenance fees.

Determine when a contract is coming due in the next 45 days.
Create a message that warns when the payment is coming...

by musical1
Replies
6
Views
1,427

Hans, that was awesome! I blinked and 22 pages were converted!

THANK YOU!

by musical1
Replies
6
Views
1,427

Here's a sample of what I am working with.

by musical1
Replies
6
Views
1,427

Reading through the code, it makes sense to me, but it doesn't seem to work.
My cursor does go to the beginning of the document, but then it just sits there.
I tried stepping through the code, but...

by musical1
Replies
6
Views
1,427

I have some documents that have 25% gray shading. When we scan the document, it is coming out too dark, SO... I need to replace all 25%Gray with 12.5% Gray.
I can't seem to create a macro that...

by musical1
Replies
3
Views
823

Thank You!
19. ## Thread: Simplified Formula (EXCEL 2003)

by musical1
Replies
3
Views
823

### Simplified Formula (EXCEL 2003)

For the attached spreadsheet, is there a way to simplify the formula in C2:C5?
i.e. remove the ISNUMBER function.

by musical1
Replies
2
Views
612

### Re: Lookup (2003)

THANK YOU! I tried for 2 hours (obviously unsuccessfully).
It was PERFECT!

by musical1
Replies
2
Views
612

### Lookup (2003)

I want to take a value ('TC Scenario'!A5), go to another data sheet ('Dose chart'!) and find that value between cells B8:E8.

Once I have located the associated column, I want to scan down the...
22. ## Thread: Nested IF/AND with lots of ORs (2003)

by musical1
Replies
5
Views
831

### Re: Nested IF/AND with lots of ORs (2003)

When I first saw your post, I thought to myself... "beginner"... stick to the basics and what you almost know.

Then, wouldn't you know, I maxed out the space avaliable in the cell (formula too...
23. ## Thread: Nested IF, AND, OR (2003)

by musical1
Replies
6
Views
588

### Re: Nested IF, AND, OR (2003)

UPDATE: The above tutorial is _wonderful_. Based on your methodology, I was able to create a formula with almost twice the criteria.

I left out a couple of the...
24. ## Thread: Nested IF, AND, OR (2003)

by musical1
Replies
6
Views
588

### Re: Nested IF, AND, OR (2003)

Thank you _again_ Hans!

I seem to get really twisted up when figuring out where the ANDs/ORs go.

by musical1
Replies
5
Views
831