Search:

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

Page 1 of 6 1

1. Thread: Return multiple values in one cell from VLOOKUP

by Fluff
Replies
5
Views
80

Re: Return multiple values in one cell from VLOOKUP

You're welcome & thanks for the feedback
2. Thread: Breaking split at not 0

by Fluff
Replies
7
Views
99

Re: Breaking split at not 0

Assuming the first value is in A2, try this in A3 & copy down
=TEXT(A2+4,"00000000")
3. Thread: Return multiple values in one cell from VLOOKUP

by Fluff
Replies
5
Views
80

Re: Return multiple values in one cell from VLOOKUP

If you have the TEXTJOIN function you could use
=TEXTJOIN(", ",1,IF(ISNUMBER(SEARCH(B11,A1:A8)),B1:B8,""))

Confirmed with Ctrl Shift Enter, not just Enter.
4. Thread: Formatting Half of the Cell data in formula

by Fluff
Replies
10
Views
94

Re: Formatting Half of the Cell data in formula

Whilst I am an MVP on this site, that does not mean I know everything (far from it).
Somebody else may come along & prove me wrong.
5. Thread: Return multiple values in one cell from VLOOKUP

by Fluff
Replies
5
Views
80

Re: Return multiple values in one cell from VLOOKUP

Hi & welcome to MrExcel.
Try
=CHOOSE(SUMPRODUCT(--(ISNUMBER(SEARCH(B11,A1:A8)))),
VLOOKUP("*"&B11&"*",A1:B8,2,FALSE),
VLOOKUP("*"&B11&"*",A1:B8,2,FALSE)&", "&INDEX(B1:B8,MATCH(B11,A1:A8,0)+1),...
6. Thread: Formatting Half of the Cell data in formula

by Fluff
Replies
10
Views
94

Re: Formatting Half of the Cell data in formula

Unfortunately I do not believe that is possible.
7. Thread: Simple IF

by Fluff
Replies
7
Views
72

Re: Simple IF

Glad we could help & thanks for the feedback
8. Thread: Simple IF

by Fluff
Replies
7
Views
72

Re: Simple IF

My suggestion was simply based on your original description.
9. Thread: Keep Top 5 Lines of Filtered Range - Delete the rest

by Fluff
Replies
7
Views
113

Re: Keep Top 5 Lines of Filtered Range - Delete the rest

Scrub the previous code and try this instead
Dim x As Long, i As Long
Dim Cl As Range
Dim Hospital As String

For x = 1 To 52
i = 0
Hospital =...
10. Thread: Automatically name worksheets based on cell values from master sheet

by Fluff
Replies
22
Views
307

Re: Automatically name worksheets based on cell values from master sheet

You're welcome & thanks for the feedback
11. Thread: Automatically name worksheets based on cell values from master sheet

by Fluff
Replies
22
Views
307

Re: Automatically name worksheets based on cell values from master sheet

Oops, I forgot to put the . before cells, it should be
Sheets.Add(, Sheets(Sheets.Count)).Name = .Cells(i, 1)
12. Thread: Cells changing colour

by Fluff
Replies
15
Views
153

Re: Cells changing colour

Glad to help & thanks for the feedback
13. Thread: Extracting City and State from a cell without commas

by Fluff
Replies
8
Views
153

Re: Extracting City and State from a cell without commas

Having re-read the op I think you're right & I have a feeling the the / or - is only in some cells but not all.
14. Thread: Simple IF

by Fluff
Replies
7
Views
72

Re: Simple IF

Another way
=IF(B2="","","k"&RIGHT(B2,1)+1)
15. Thread: Cells changing colour

by Fluff
Replies
15
Views
153

Re: Cells changing colour

Ok, that's right, but the formula should be
=AND(ISNUMBER(\$A1),ISNUMBER(\$B1))
I forgot to lock the range
16. Thread: Extracting City and State from a cell without commas

by Fluff
Replies
8
Views
153

Re: Extracting City and State from a cell without commas

:confused: It's not looking for a space, It's simply pulling everything after the / or -.
If the op wants to split the data further (or add spaces if needed) then as you've said we'll need to wait...
17. Thread: Automatically name worksheets based on cell values from master sheet

by Fluff
Replies
22
Views
307

Re: Automatically name worksheets based on cell values from master sheet

Yup, use this
Sheets.Add(, Sheets(Sheets.Count)).Name = Cells(i, 1)
18. Thread: User Forms and Global Variable

by Fluff
Replies
3
Views
48

Re: User Forms and Global Variable

It's because you are declaring them again in the sub. Remove the part in red
Public wsA As Worksheet, wbA As Workbook
Sub NewExpense()
Dim sExpDesc As String, sReplace As String, sAccName As...
19. Thread: Count Unique Values

by Fluff
Replies
5
Views
119

Re: Count Unique Values

Have a look here
https://exceljet.net/formula/count-unique-text-values-with-criteria
20. Thread: Extracting City and State from a cell without commas

by Fluff
Replies
8
Views
153

Re: Extracting City and State from a cell without commas

If this is always the case, you could use
=MID(A2,FIND("/",SUBSTITUTE(A2,"-","/"))+1,500)
21. Thread: Keep Top 5 Lines of Filtered Range - Delete the rest

by Fluff
Replies
7
Views
113

Re: Keep Top 5 Lines of Filtered Range - Delete the rest

EDIT:
Code removed as it was wrong.
22. Thread: Keep Top 5 Lines of Filtered Range - Delete the rest

by Fluff
Replies
7
Views
113

Re: Keep Top 5 Lines of Filtered Range - Delete the rest

Glad you sorted it & thanks for the feedback
23. Thread: Build formula based off value in another Cell

by Fluff
Replies
4
Views
86

Re: Build formula based off value in another Cell

Glad we could help & thanks for the feedback
24. Thread: Automatically name worksheets based on cell values from master sheet

by Fluff
Replies
22
Views
307

Re: Automatically name worksheets based on cell values from master sheet

Sub timlh42()
Dim i As Long

With Sheets("Sheet1")
For i = 3 To 30
If .Cells(i, 1) <> 22 Then
If Not Evaluate("isref('" & .Cells(i, 1)...
25. Thread: Counting the number of blank cells between a specific value

by Fluff
Replies
1
Views
59

Re: Counting the number of blank cells between a specific value

Hi & welcome to MrExcel.
One way
=AGGREGATE(15,6,COLUMN(B2:F2)/(B2:F2<>""),2)-AGGREGATE(15,6,COLUMN(B2:F2)/(B2:F2<>""),1)-1
Results 1 to 25 of 150
Page 1 of 6 1