# Search:

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

Page 1 of 6 1

## Search: Search took 0.01 seconds.

by Finalfight40
Replies
5
Views
150

### Re: Help, required single formula, instead of using 3

Ignore this, found a problem with it.
2. ## Thread: Find highest number when mixedwith text in each cell

by Finalfight40
Replies
3
Views
122

### Re: Find highest number when mixedwith text in each cell

Would this work?

=VLOOKUP("*"&MAX(RIGHT(A2:A5, 4)+0), A2:A5, 1, FALSE)

Would need to adjust the range.

Entered as an array with ctrl + shift+ enter.
3. ## Thread: How to calculate compound interest?

by Finalfight40
Replies
16
Views
511

### Re: How to calculate compound interest?

Also i just want to add something else you said which either i misunderstood or James missed.

For your newest example did you want to add 10% interest AND an extra \$10 each week?
4. ## Thread: How to calculate compound interest?

by Finalfight40
Replies
16
Views
511

### Re: How to calculate compound interest?

Can you not use the same idea provided in the link by Special-k99?

Where you have

=A1*(1+B1)^C1

where A1 is the initial value
B1 is the interest
C1 is the number of weeks
5. ## Thread: VBA - With each table on Activesheet

by Finalfight40
Replies
17
Views
362

### Re: VBA - With each table on Activesheet

Thank you for your help and time with this Peter. It seems this has now resolved my issue.
6. ## Thread: VBA - With each table on Activesheet

by Finalfight40
Replies
17
Views
362

### Re: VBA - With each table on Activesheet

I have created a new spreadsheet so that i can replicate the issue and share it with you. I have uploaded it to dropbox and this link is:
...
7. ## Thread: VBA - With each table on Activesheet

by Finalfight40
Replies
17
Views
362

### Re: VBA - With each table on Activesheet

Hi Peter

The only thing i added was something like:

Range("G1").select
Range("F1").select

at the end just so that it would run the on worksheet change event (or one of the events)...
8. ## Thread: VBA - With each table on Activesheet

by Finalfight40
Replies
17
Views
362

### Re: VBA - With each table on Activesheet

Just a follow up, it looks to be happening on tables which are empty.
9. ## Thread: VBA - With each table on Activesheet

by Finalfight40
Replies
17
Views
362

### Re: VBA - With each table on Activesheet

Hi Peter

i have just found that on some sheets i am receiving a run time error '91' and the line that is being highlighted is:

10. ## Thread: VBA - With each table on Activesheet

by Finalfight40
Replies
17
Views
362

### Re: VBA - With each table on Activesheet

Thank you Peter. This works perfectly for me at the moment, i will let you know if i run into any issues.

I was unaware the 1 element and no elements were going to be relevant.

As for the...
11. ## Thread: VBA - With each table on Activesheet

by Finalfight40
Replies
17
Views
362

### Re: VBA - With each table on Activesheet

Hi Norie and all

I have had an run time error '91'.

I believe this is where the tables are currently empty.

I want to expand and mention that these tables can have nothing in them. Also the...
12. ## Thread: VBA - With each table on Activesheet

by Finalfight40
Replies
17
Views
362

### Re: VBA - With each table on Activesheet

Hi Peter

For one of my tables i got an error which was :

Paste method of range class failed and i have changed to red above where this error was received.

Also i am going to explain a little...
13. ## Thread: VBA - With each table on Activesheet

by Finalfight40
Replies
17
Views
362

### Re: VBA - With each table on Activesheet

o Norie.

Thank you so much this works perfectly.

I haven't had any experience with tables in VBA so i really appreciate it.
14. ## Thread: VBA - With each table on Activesheet

by Finalfight40
Replies
17
Views
362

### VBA - With each table on Activesheet

Hi

I am trying to set something up in VBA where it would cycle through each table on the Activesheet and if the 3rd column header says "Start Date" then add 7 for each element on the 3rd column of...
15. ## Thread: Contatenate with blanks

by Finalfight40
Replies
2
Views
63

### Re: Contatenate with blanks

Something like this?

=IF(OR(B1="", C1=""), "", B1 & " " & C1)
16. ## Thread: Sum Largest Negative and Positive Question

by Finalfight40
Replies
6
Views
164

### Re: Sum Largest Negative and Positive Question

In your example wouldn't the largest possible sum be 4 since 7 + (-3) = 4

and also the largest negative sum be -5 since (-2) + (-3) = -5 ?

if so try:

=MAX(A1, A1:A5+A2:A6)

and
17. ## Thread: How to get sum to jump 3 columns

by Finalfight40
Replies
7
Views
193

### Re: How to get sum to jump 3 columns

After re reading i noticed you wanted to drag right, not down:

=SUM(OFFSET(Sheet1!\$A\$20:\$C\$20,,3*(COLUMNS(\$A\$1:A1)-1)))
18. ## Thread: How to get sum to jump 3 columns

by Finalfight40
Replies
7
Views
193

19. ## Thread: How to get sum to jump 3 columns

by Finalfight40
Replies
7
Views
193

### Re: How to get sum to jump 3 columns

=SUM(OFFSET(Sheet1!\$A\$20:\$C\$20,,3*(ROWS(\$A\$1:A1)-1)))

Does this do what you want assuming your data is in A20:C20 on sheet 1?
20. ## Thread: Issue getting the value from an array instead of index

by Finalfight40
Replies
5
Views
111

### Re: Issue getting the value from an array instead of index

It's always the way haha.
21. ## Thread: Issue getting the value from an array instead of index

by Finalfight40
Replies
5
Views
111

### Re: Issue getting the value from an array instead of index

Like this?

Sub GetOutPut()

Dim V1, V2, V3, V4, V5
Dim TheList
Dim output

by Finalfight40
Replies
0
Views
498

### Google Sheets - Script Dates

Hi All

I am having a problem with making a script. I am making a script that will delete a row a week after something has been approved.

As of right now i have this which when a dropdown...
23. ## Thread: enter 1 if cell is negative number, zero if positive

by Finalfight40
Replies
3
Views
121

### Re: enter 1 if cell is negative number, zero if positive

=IF(G1<0, 1, 0)

although are you counting 0 as positive or negative?
24. ## Thread: Concatenate question to remove a period (everything but this already figured out)

by Finalfight40
Replies
4
Views
133

### Re: Concatenate question to remove a period (everything but this already figured out)

Its from your mid function i believe. You can change it to:

=concatenate("+1",left(N2,3),"",mid(N2,5,3),"",right(N2,4))

but i would just use:

="+1" & SUBSTITUTE(N2, ".", "")

by Finalfight40
Replies
7
Views
139

### Re: Excel Help, nested formulas

Like this?

=IF(T2=0,IF(ISNUMBER(SEARCH("Redemption",E2)),"Redemption",IF(ISNUMBER(SEARCH("Subscription",E2)),"Subscription",)),"Exchange"&IF(ISNUMBER(SEARCH("Index",P2))," - Index",""))
Results 1 to 25 of 150
Page 1 of 6 1