Search:

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

Page 1 of 6 1

1. Thread: SUM only numbers in a cell that also contains text.

by Finalfight40
Replies
6
Views
67

Re: SUM only numbers in a cell that also contains text.

Happy it works for you.

The first option is just looking to the right of the space of each cell since you have a space before each number and the second option is just replacing the "Achieved"...
2. Thread: SUM only numbers in a cell that also contains text.

by Finalfight40
Replies
6
Views
67

Re: SUM only numbers in a cell that also contains text.

Or:

=SUM(SUBSTITUTE(G65, "Achieved", ""), SUBSTITUTE(K65, "Achieved", ""), SUBSTITUTE(O65, "Achieved", ""), SUBSTITUTE(S65, "Achieved", ""))
3. Thread: SUM only numbers in a cell that also contains text.

by Finalfight40
Replies
6
Views
67

Re: SUM only numbers in a cell that also contains text.

As the cells are all going to be formatted the same, you can try something like the below:

=SUM(RIGHT(G65,LEN(G65)-SEARCH(" ",G65)),RIGHT(K65,LEN(K65)-SEARCH(" ",K65)), RIGHT(O65,LEN(O65)-SEARCH("...

by Finalfight40
Replies
5
Views
160

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

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

by Finalfight40
Replies
3
Views
132

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.
6. 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?
7. 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
8. Thread: VBA - With each table on Activesheet

by Finalfight40
Replies
17
Views
363

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.
9. Thread: VBA - With each table on Activesheet

by Finalfight40
Replies
17
Views
363

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:
...
10. Thread: VBA - With each table on Activesheet

by Finalfight40
Replies
17
Views
363

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)...
11. Thread: VBA - With each table on Activesheet

by Finalfight40
Replies
17
Views
363

Re: VBA - With each table on Activesheet

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

by Finalfight40
Replies
17
Views
363

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:

13. Thread: VBA - With each table on Activesheet

by Finalfight40
Replies
17
Views
363

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...
14. Thread: VBA - With each table on Activesheet

by Finalfight40
Replies
17
Views
363

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...
15. Thread: VBA - With each table on Activesheet

by Finalfight40
Replies
17
Views
363

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...
16. Thread: VBA - With each table on Activesheet

by Finalfight40
Replies
17
Views
363

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.
17. Thread: VBA - With each table on Activesheet

by Finalfight40
Replies
17
Views
363

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...

by Finalfight40
Replies
2
Views
64

Re: Contatenate with blanks

Something like this?

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

by Finalfight40
Replies
6
Views
168

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
20. Thread: How to get sum to jump 3 columns

by Finalfight40
Replies
7
Views
194

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)))
21. Thread: How to get sum to jump 3 columns

by Finalfight40
Replies
7
Views
194

22. Thread: How to get sum to jump 3 columns

by Finalfight40
Replies
7
Views
194

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?
23. Thread: Issue getting the value from an array instead of index

by Finalfight40
Replies
5
Views
113

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

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

by Finalfight40
Replies
5
Views
113

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
501