Search:

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

Page 1 of 6 1

1. Thread: how to divide and unique names in to one slicer

by gaz_chops
Replies
11
Views
220

Re: how to divide and unique names in to one slicer

Use text to columns.

Highlight the column with the data in
Select Data then Text to Columns
Click next
Check Comma
Select finish
2. Thread: how to divide and unique names in to one slicer

by gaz_chops
Replies
11
Views
220

Re: how to divide and unique names in to one slicer

I doubt many will want to open a zip file!
Better if you post a sample and an explanation of what you are trying to achieve.
3. Thread: Formula to add values from two columns ingoring one if the other has an amount in it?

by gaz_chops
Replies
7
Views
159

Re: Formula to add values from two columns ingoring one if the other has an amount in it?

You're welcome.
4. Thread: Formula to add values from two columns ingoring one if the other has an amount in it?

by gaz_chops
Replies
7
Views
159

Re: Formula to add values from two columns ingoring one if the other has an amount in it?

That is what my suggestion does!

<tbody>
5
5. Thread: Formula to add values from two columns ingoring one if the other has an amount in it?

by gaz_chops
Replies
7
Views
159

Re: Formula to add values from two columns ingoring one if the other has an amount in it?

Maybe

=SUMIFS(D20:D250,F20:F250,"")+SUM(F20:F250)
6. Thread: How to add spaces to the both sides of text in a cell

by gaz_chops
Replies
15
Views
409

Re: How to add spaces to the both sides of text in a cell

Is it always 4 spaces at the beginning & 7 spaces at the end?

by gaz_chops
Replies
6
Views
113

Re: Require formula

Or maybe

=SUBSTITUTE(TRIM(SUBSTITUTE(A1,","," "))," ",",")

by gaz_chops
Replies
4
Views
98

Re: Simple String question

If they are always separated by | then you could simply use Text to Columns with | as the separator.
9. Thread: Index Match, sum if or vlookup?

by gaz_chops
Replies
10
Views
410

Re: Index Match, sum if or vlookup?

Another way

=SUM(OFFSET(\$C\$1,MATCH(\$B\$10&\$A\$10,\$A\$2:\$A\$5&\$B\$2:\$B\$5,0),,,MATCH(\$A\$11,\$C\$1:\$F\$1,0)))
Enter as an array with Ctrl, Shift & Enter

<tbody>

by gaz_chops
Replies
6
Views
161

Re: sum time

This also works & is not an array formula

=SUMPRODUCT(A1:A6+0)

by gaz_chops
Replies
6
Views
161

Re: sum time

You're welcome.

by gaz_chops
Replies
6
Views
161

Re: sum time

Try

=SUM(A1:A6+0)
Enter as an array with Ctrl, Shift & Enter

by gaz_chops
Replies
6
Views
161

Re: sum time

Have you tried to sum them? If they are entered as you show them then it should work.

<tbody>
00:00:15

00:00:48
14. Thread: Check if a cell contains same digits

by gaz_chops
Replies
36
Views
831

Re: Check if a cell contains same digits

A non array formula

=SUBSTITUTE(A1,LEFT(A1,1),"")=""
15. Thread: Connecting cells and flipping the data between two values

by gaz_chops
Replies
2
Views
143

Re: Connecting cells and flipping the data between two values

If your data starts in cell A1, then try

In cell B1 Enter =A1=FALSE
In cell C1 Enter =B1
In cell D1 Enter =C1=FALSE
In cell E1 Enter =D1
In cell F1 Enter =E1=FALSE
16. Thread: Count number of times a specific text appears in a string & range

by gaz_chops
Replies
9
Views
200

Re: Count number of times a specific text appears in a string & range

What is the criteria whereby the search value is counted, or not?
17. Thread: Count number of times a specific text appears in a string & range

by gaz_chops
Replies
9
Views
200

Re: Count number of times a specific text appears in a string & range

Try

=SUM(--ISNUMBER(FIND(B1,A1:A3)))

enter as an array with Ctrl, Shift Enter

by gaz_chops
Replies
6
Views
198

Re: Array Formula Issue

Try

=SMALL(IF((\$B\$3:\$B\$26>=10)*(\$B\$3:\$B\$26<=15),\$B\$3:\$B\$26),ROW()-2)
19. Thread: Sum if based on horizontal and vertical criteria

by gaz_chops
Replies
3
Views
185

Re: Sum if based on horizontal and vertical criteria

Maybe

=SUMPRODUCT((\$C\$1:\$E\$1=\$A11)*(\$B\$2:\$B\$6=B\$10)*(\$C\$2:\$E\$6))
20. Thread: Countif, suproduct, etc. Formula needed

by gaz_chops
Replies
3
Views
167

Re: Countif, suproduct, etc. Formula needed

You're welcome.
21. Thread: Calculation to have cell turn red or yellow

by gaz_chops
Replies
3
Views
234

Re: Calculation to have cell turn red or yellow

You're welcome, thanks for the feedback.
22. Thread: Countif, suproduct, etc. Formula needed

by gaz_chops
Replies
3
Views
167

Re: Countif, suproduct, etc. Formula needed

In B1 enter 1, in B2 enter

=IF(A2="","",IF(A2=A1,B1,B1+1))

copy down range
23. Thread: Calculation to have cell turn red or yellow

by gaz_chops
Replies
3
Views
234

Re: Calculation to have cell turn red or yellow

In conditional formatting, use

For yellow
=ABS(A10-C10)<=1

For Red
=ABS(A10-C10)>1
24. Thread: I need to make Sum with 3 criterias

by gaz_chops
Replies
4
Views
268

Re: I need to make Sum with 3 criterias

With the information you have provided, it's not possible. Give more details of the data/structure etc.
25. Thread: I need to make Sum with 3 criterias

by gaz_chops
Replies
4
Views
268

Re: I need to make Sum with 3 criterias

Try sumifs

=sumifs(sum range, criteria range, criteria, criteria range, criteria)
Results 1 to 25 of 150
Page 1 of 6 1