TEXTJOIN with IF conditions, but not showing correct format?

Miarie

New Member
Joined
Jan 14, 2022
Messages
4
Office Version
  1. 365
Platform
  1. Windows
Hello,

So I am trying to use the formula to join all of the data from 1 sheet into a cell if there are multiple rows with the same data on.

It work's for the most part, however the date I want to join together are all percentages, and it keeps joining the data not in a percentage format...

Is there anyway to do this at all?

This is the current formula I am trying to work with:
=ArrayFormula(TEXTJOIN(" - ",TRUE,IF('Saving Calculator'!B15:B45=B43,'Saving Calculator'!C15:C45,"")))

The percentages I want to try and join together are in the C column, and the word it is looking for to match with is in the B column

I have a feeling it will have something to do with TEXT function, but no idea where about to incorporate it into the formula :/
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
67,753
Office Version
  1. 365
Platform
  1. Windows
Is this for Google Sheets or Excel?
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
60,742
Office Version
  1. 365
Platform
  1. Windows
Its for a Google Sheet

Google Sheet
Then you do not want to post it to the "Excel Questions" forum (while they are similar in a lot of respects, they are NOT exactly the same).

You want to post it to the "General Discussion & Other Applications" forum. Note the description on that one:

1642188776696.png


I have moved it for you.
 

Miarie

New Member
Joined
Jan 14, 2022
Messages
4
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

Then you do not want to post it to the "Excel Questions" forum (while they are similar in a lot of respects, they are NOT exactly the same).

You want to post it to the "General Discussion & Other Applications" forum. Note the description on that one:

View attachment 55252

I have moved it for you.
ok thank you very much, and apologies, very new to the forum
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
60,742
Office Version
  1. 365
Platform
  1. Windows
ok thank you very much, and apologies, very new to the forum
No worries.

Hopefully someone who uses Google Sheets will be able to help.
I know that in Excel, any kind of concatenate does NOT maintain cell formatting, so you need to use the TEXT function in Excel to maintain.

So, in Excel, if you have 5.00% in cell M1, and you wanted to write in another cell "Total is 5.00%, you could do it like this:
="Total is " & TEXT(M1,"0.00%")

I am not sure if you do it the same way in Google Sheets or not (having to use the TEXT function to format the numeric value).
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
67,753
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

Not sure if this works with sheets, but try
Excel Formula:
=ArrayFormula(TEXTJOIN(" - ",TRUE,TEXT(IF('Saving Calculator'!B15:B45=B43,'Saving Calculator'!C15:C45,""),"0%")))
 
Solution

Miarie

New Member
Joined
Jan 14, 2022
Messages
4
Office Version
  1. 365
Platform
  1. Windows
Not sure if this works with sheets, but try
Excel Formula:
=ArrayFormula(TEXTJOIN(" - ",TRUE,TEXT(IF('Saving Calculator'!B15:B45=B43,'Saving Calculator'!C15:C45,""),"0%")))
Yes this worked! thank you sooooooooooooooo much!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
67,753
Office Version
  1. 365
Platform
  1. Windows
Glad we could help & thanks for the feedback.
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,470
Messages
5,764,513
Members
425,221
Latest member
MercedesCLK

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top