# Search:

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

Page 1 of 4 1

1. ## Thread: I'd like to make a FOOD schedule spread sheet

by sooshil
Replies
19
Views
516

### Re: I'd like to make a FOOD schedule spread sheet

This calculates as follows.
If you entered three of your meal times then it first calculates the difference between first and second meal and then the difference between third and second meal. Then...
2. ## Thread: I'd like to make a FOOD schedule spread sheet

by sooshil
Replies
19
Views
516

### Re: I'd like to make a FOOD schedule spread sheet

Sorry for being late.
But, I hope now, it works for you.
3. ## Thread: I'd like to make a FOOD schedule spread sheet

by sooshil
Replies
19
Views
516

### Re: I'd like to make a FOOD schedule spread sheet

Wow! So sweet of you.
I really appreciate it. By the way, I left Canberra last year. I am now in the US.

As soon as I get some extra time, I will work on your problem and provide the solution...
4. ## Thread: I'd like to make a FOOD schedule spread sheet

by sooshil
Replies
19
Views
516

### Re: I'd like to make a FOOD schedule spread sheet

It is absolutely possible. For simplicity, I did use the midnight format.
5. ## Thread: I'd like to make a FOOD schedule spread sheet

by sooshil
Replies
19
Views
516

### Re: I'd like to make a FOOD schedule spread sheet

I have referenced 12:00 midnight as base in the formula. So I advise not to use 12:00 instead use 12:01.
This will solve the problem.
And, yes, one row is for one day for the current formula.
6. ## Thread: Is it possible to define a name which consists text with double quotes?

by sooshil
Replies
3
Views
152

### Re: Is it possible to define a name which consists text with double quotes?

Thank you Rick Rothstein for this awesome solution.
7. ## Thread: I'd like to make a FOOD schedule spread sheet

by sooshil
Replies
19
Views
516

### Re: I'd like to make a FOOD schedule spread sheet

Here is the solution.
Please make sure, if your time goes beyond midnight, you enter that time into the next day.

...
8. ## Thread: Help with CHOOSE function

by sooshil
Replies
9
Views
196

### Re: Help with CHOOSE function

DanteAmor

Sorry for the misunderstanding. Yes the way FormR suggested works fine.
At first I was looking to give those values to CHOOSE as a named range.
Then you suggested to use INDEX, I...
9. ## Thread: Help with CHOOSE function

by sooshil
Replies
9
Views
196

### Re: Help with CHOOSE function

No.
I was talking about Excel Formula not a macro or VBA.
��
10. ## Thread: Help with CHOOSE function

by sooshil
Replies
9
Views
196

### Re: Help with CHOOSE function

Thank you so much for both of you for your effort.
I really appreciate it.
11. ## Thread: I'd like to make a FOOD schedule spread sheet

by sooshil
Replies
19
Views
516

### Re: I'd like to make a FOOD schedule spread sheet

Text being partly hidden is just the problem of some formatting on cell alignment.
Here is the link for the file.
12. ## Thread: I'd like to make a FOOD schedule spread sheet

by sooshil
Replies
19
Views
516

### Re: I'd like to make a FOOD schedule spread sheet

Make sure you enter your time to every column you have created to get the better...
13. ## Thread: Help with CHOOSE function

by sooshil
Replies
9
Views
196

### Re: Help with CHOOSE function

I tried that approach too. That didn't work.
If I hardcode the array inside Index, it works, but when I put the Name, It gives #REF error.
Any more thought on it?
14. ## Thread: I'd like to make a FOOD schedule spread sheet

by sooshil
Replies
19
Views
516

### Re: I'd like to make a FOOD schedule spread sheet

Use this formula to cell AH3

It gives your average hours and minutes of that day in time format.
Take average of the column at the end of the...
15. ## Thread: Help with CHOOSE function

by sooshil
Replies
9
Views
196

### Help with CHOOSE function

CHOOSE function has syntax

CHOOSE(index_num, value1, [value2], ...)

I have 100s of values (text values) to deliver to CHOOSE function. Instead of typing all those values every time, I want to...
16. ## Thread: Count rows that contain multiple values in multiple columns

by sooshil
Replies
10
Views
284

### Re: Count rows that contain multiple values in multiple columns

This formula fails when a number repeats and another number is absent. How can this problem be addressed?
I am here just to learn something. This may not be the requirement of the original question....
17. ## Thread: Is it possible to define a name which consists text with double quotes?

by sooshil
Replies
3
Views
152

### Is it possible to define a name which consists text with double quotes?

Hi,

I have a requirement in my formula that certain strings gets repeated. I want to put that string as a defined name. Here is an example of such string:

" One"," Two"," Three"," Four","...

by sooshil
Replies
7
Views
249

### Re: Adding Cricket Overs with VBA with parameters

Hi @Fluff

Can JackDanIce's VBA be modified so that the function AddOvers() can take arguments as SUM function takes?

by sooshil
Replies
7
Views
249

### Re: Adding Cricket Overs with VBA with parameters

Thank you both for the answers.
The built in function DOLLARFE and DOLLARDE works quite bit. But I have to click every cell I want to add.
The VBA given by JackDanIce also adds up a contagious...

by sooshil
Replies
7
Views
249

### Adding Cricket Overs with VBA with parameters

Hi

In Cricket Sports there are 6 legal balls a bowler bowls towards the batsman. Those 6 balls are called an over.
So, the sequence of the balls are counted as follows.
1 ball = 0.1 overs
2...

by sooshil
Replies
11
Views
353

### Re: Sum non adjacent cells with criteria

I am getting Run-time Error 1004
Application defined or object defined error

When I click Debug, it yellow highlights line
c.Offset(, 2).Value = c.Offset(, 2).Value + f.Offset(n, 1).Value
...
22. ## Thread: Small VBA code needed for delete with criteria

by sooshil
Replies
7
Views
116

### Re: Small VBA code needed for delete with criteria

I am very sorry. At first I gave you the wrong/opposite criteria.
I am able to fix that by replacing <> with an = sign.
That worked great.
Thank you Joe again.

Now, can I make this macro run...
23. ## Thread: Small VBA code needed for delete with criteria

by sooshil
Replies
7
Views
116

### Re: Small VBA code needed for delete with criteria

I am sorry. I give you the opposite criteria. I have to delete the ranges if the criteria is empty or equals to "".
24. ## Thread: Small VBA code needed for delete with criteria

by sooshil
Replies
7
Views
116

### Re: Small VBA code needed for delete with criteria

Hello Joe

Yes, there is absolutely a rhyme.
The criteria cells are as follows...
B3, H3, N3
B8, H8, N8
B13, H13, N13
B18, H18, N18

and so on...
25. ## Thread: Small VBA code needed for delete with criteria

by sooshil
Replies
7
Views
116

### Small VBA code needed for delete with criteria

Hi all

I want to delete contents of a sheet based upon some criteria. I am very basic in VBA. I created Select and ClearContent by recording macro. :) But, I am not sure how to add criteria.
Here...
Results 1 to 25 of 76
Page 1 of 4 1