# Search:

Type: Posts; User: Special-K99; Keyword(s):

Page 1 of 6 1

1. ## Thread: Code Particular Strings As Numbers, Then Sum Numbers

by Special-K99
Replies
1
Views
20

### Re: Code Particular Strings As Numbers, Then Sum Numbers

This works based on your somewhat vague description, cos I can see you expanding your request and this no longer working, so your description isn't specific enough.
But this will work on what you've...
2. ## Thread: Move Columns

by Special-K99
Replies
1
Views
27

### Re: Move Columns

Formulas cannot change other cell values.
Formulas can read other cell values and calculate results from that.

Specifically what are you trying to do, what are the formulas you start with and...
3. ## Thread: VBA to Javascript

by Special-K99
Replies
1
Views
9

### Re: VBA to Javascript

Well if you wrote it, you know what it does and how it works.
So shouldn't this request be in a Javascript forum?

That's like writing a story in French, wanting to translate it into German, but...
4. ## Thread: Total Empty column between two characters

by Special-K99
Replies
15
Views
278

### Re: Total Empty column between two characters

in A1
=IF(AND(A2="",B2="A"),COLUMN()-MAX(IF(\$A2:A2="A",COLUMN((\$A2:A2)))),"")
Array formula, use Ctrl-Shift-Enter

copy along as far as AA1
5. ## Thread: IF statement

by Special-K99
Replies
1
Views
28

### Re: IF statement

Remove the brackets around S80, you don't need them

Do you mean this, it's not clear.

=IF(Y80<>"","",IF(S80<>"",S80+41,""))
6. ## Thread: How to get the earliest time by row

by Special-K99
Replies
5
Views
100

### Re: How to get the earliest time by row

Fred Responded 15/07/2019 08:30 Delivered 15/07/2019 09:30 15/07/2019 07:30

Why is the result of this 07:30 ?
There is no 07:30 in that row
The earliest is 08:30
7. ## Thread: Finding number between range of numbers?

by Special-K99
Replies
1
Views
144

### Re: Finding number between range of numbers?

Why not just use Ctrl-F to find the number?

You need to specify clearly where the numbers are - are in they in a column? Which column? - are they in a row? Which row?
What cell are you storing...
8. ## Thread: Sumproduct and if statement

by Special-K99
Replies
5
Views
38

### Re: Sumproduct and if statement

if you mean OR then

=SUMPRODUCT(((Statement!\$J\$1:\$J\$1724="Subscription Fees")+(Statement!\$J\$1:\$J\$1724="Income")) *(Statement!\$L\$1:\$L\$1724))
9. ## Thread: Sumproduct and if statement

by Special-K99
Replies
5
Views
38

### Re: Sumproduct and if statement

Where column J is "Subscription Fees" AND "Income"

How can something be 2 things at once?
Do you mean OR ?
Do you mean

Where column J is "Subscription Fees" OR "Income"

"There is another...
10. ## Thread: How to display data from one sheet if blank or another if filled

by Special-K99
Replies
10
Views
267

### Re: How to display data from one sheet if blank or another if filled

Remove all \$ from the formula
You dont see any \$ in my formula do you?
11. ## Thread: "double" INDEX & MATCH search?

by Special-K99
Replies
12
Views
163

### Re: "double" INDEX & MATCH search?

"See attached test"

FYI
You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

12. ## Thread: Transpose Data to Create new table

by Special-K99
Replies
10
Views
201

### Re: Transpose Data to Create new table

I doubt I'll answer this as I'm busy at work but

in the New Table

why does 2400 appear in the 31-60 column for All-Good 11/26/2018 ?
The value is 7200 which doesn't appear ANYWHERE in the New...
13. ## Thread: Index match

by Special-K99
Replies
5
Views
227

### Re: Index match

Is this a typo ???

=INDEX(K27:N27+MATCH(H28,J28:J33,0),MATCH(H29,K28:N33))

It should be

=INDEX(K27:N27,MATCH(H28,J28:J33,0),MATCH(H29,K28:N33))

For subsequent dates you'd be better off...
14. ## Thread: Detect fill colour in cells

by Special-K99
Replies
4
Views
59

### Re: Detect fill colour in cells

I'm not an expert on VBA and certainly haven't delved into the "detecting colours" side of VBA :(
15. ## Thread: Miscounting in column T

by Special-K99
Replies
3
Views
89

### Re: Miscounting in column T

No it doesn't.

You have the value 151 in K3, that plus a non zero value in E3 counts as 2.
Excel is correct.

Column K has data that you haven't displayed correctly.
Change the colour column...
16. ## Thread: If Column X contains specific text in Column Y then SUM Column Z

by Special-K99
Replies
2
Views
55

### Re: If Column X contains specific text in Column Y then SUM Column Z

1. Lacking in example data, so this may not work, more test data = more accurate solution.

2. Your subject says SUM Column Z.
There is NO column Z in your example data.

To set column D to...
17. ## Thread: Excel Transpose (T) From Column to Row specific position.

by Special-K99
Replies
6
Views
136

### Re: Excel Transpose (T) From Column to Row specific position.

Here's a formula solution, you will have to make adjustments on this as you have not supplied any cell reference data.

This assumes the following

Your original data is in A\$2:A\$1000, adjust...
18. ## Thread: Excel Transpose (T) From Column to Row specific position.

by Special-K99
Replies
6
Views
136

### Re: Excel Transpose (T) From Column to Row specific position.

That does not answer my question.
Do you want a formula solution or VBA (I will not be able to help with a VBA solution as it is not my area of expertise).
19. ## Thread: Hanging, Not Responding

by Special-K99
Replies
10
Views
161

### Re: Hanging, Not Responding

"I enter data and go to another cell to enter more data. Excel is frozen at this point and won't accept any mouse click or key entry. The bar at the top of the screen says the file name followed by...
20. ## Thread: Excel Transpose (T) From Column to Row specific position.

by Special-K99
Replies
6
Views
136

### Re: Excel Transpose (T) From Column to Row specific position.

Questions

1.

Will each element of data ALWAYS have FOUR rows then ONE blank cell separating them.
FOUR rows = A, 123, 456, 789
then one BLANK row.

Is this ALWAYS the case or could it vary?
21. ## Thread: Detect fill colour in cells

by Special-K99
Replies
4
Views
59

### Re: Detect fill colour in cells

If manual shading then you have to use VBA to detect the colour of the cell, you would not be able to do this via Condtional Formatting.
If you're saying the cell...
22. ## Thread: separate something in a cell.

by Special-K99
Replies
6
Views
73

### Re: separate something in a cell.

Or use a helper column

in B21
=SUBSTITUTE(A21," > ","")
then use Text To Columns with a separater of m
This assumes that m will always be in the cell between the > signs

One piece of data...
23. ## Thread: SUMIFS - 2 conditions, 1 column

by Special-K99
Replies
4
Views
112

### Re: SUMIFS - 2 conditions, 1 column

=SUMIFS(A:A,C:C,E1,B:B,"whse 1",B:B,"whse 2")

This is an AND condition
SUM column A if column C equals E1 and column B equals "whse 1" and column B equals "whse 2"

How can a cell in column B...
24. ## Thread: Adding Logic to an Existing Formula

by Special-K99
Replies
3
Views
61

### Re: Adding Logic to an Existing Formula

in P161
=IF(D161<>"",D161,IF(ISERROR(VLOOKUP(O161,'G-Block CMO-FMO and IP Ranges '!\$A\$61:\$G\$400,2,FALSE)),"",VLOOKUP(O161,'G-Block CMO-FMO and IP Ranges '!\$A\$61:\$G\$400,2,FALSE)))
25. ## Thread: Index/Lookup

by Special-K99
Replies
6
Views
189

### Re: Index/Lookup

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images