# Search:

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

Page 1 of 9 1

1. ## Thread: Custom formatting assistance

by musical1
Replies
9
Views
1,833

### 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!
2. ## Thread: Custom formatting assistance

by musical1
Replies
9
Views
1,833

### 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.
3. ## Thread: Custom formatting assistance

by musical1
Replies
9
Views
1,833

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

Wow, that was short and sweet!

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

by musical1
Replies
9
Views
1,833

### 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...
5. ## Thread: Sum for multiple Conditions; EXCEL 2003

by musical1
Replies
4
Views
2,326

### 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
6. ## Thread: Sum for multiple Conditions; EXCEL 2003

by musical1
Replies
4
Views
2,326

### Sum for multiple Conditions; EXCEL 2003

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

by musical1
Replies
4
Views
2,326

### 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...
8. ## Thread: Pivot/Chart: sorting data

by musical1
Replies
6
Views
3,091

### 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!...
9. ## Thread: Pivot/Chart: sorting data

by musical1
Replies
6
Views
3,091

### 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...
10. ## Thread: Calculating a Due Date with criteria

by musical1
Replies
2
Views
502

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

Barron, That is sweet!

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

by musical1
Replies
2
Views
502

### 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,221

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

THANK YOU!

by musical1
Replies
6
Views
1,221

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

by musical1
Replies
6
Views
1,221

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,221

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
726

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

by musical1
Replies
3
Views
726

### 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
526

### Re: Lookup (2003)

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

by musical1
Replies
2
Views
526

### 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...
20. ## Thread: Nested IF/AND with lots of ORs (2003)

by musical1
Replies
5
Views
728

### 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...
21. ## Thread: Nested IF, AND, OR (2003)

by musical1
Replies
6
Views
523

### 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...
22. ## Thread: Nested IF, AND, OR (2003)

by musical1
Replies
6
Views
523

### 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.
23. ## Thread: Nested IF/AND with lots of ORs (2003)

by musical1
Replies
5
Views
728

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

Perfect.

Now to disect/analyse so that I can apply it to others...

<img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>
24. ## Thread: Nested IF/AND with lots of ORs (2003)

by musical1
Replies
5
Views
728

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

I'm trying to create a formula for the following:

IF K15 = "Spontaneous" and 'New Case'!K5="SP" OR "L" OR "HA" OR "SR" OR "SH","OK","Error"
OR
IF K15 = "Literature (Spon)" and 'New...
25. ## Thread: Nested IF, AND, OR (2003)

by musical1
Replies
6
Views
523

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

What I would like to do:

Read the value in Cell K19.

IF that value (in K19) = "Death or Life Threatening"
AND Cell 'New Case'!K52 OR 'New Case'!K53 = Yes, the true statement should be...
Results 1 to 25 of 213
Page 1 of 9 1