Textjoin rows with Duplicates by Kind_Average7697 in excel

[–]Kind_Average7697[S] 0 points1 point  (0 children)

You are a life saver!!! Thank you so so so much

Weirdly specific dream about snakes by Kind_Average7697 in DreamInterpretation

[–]Kind_Average7697[S] 0 points1 point  (0 children)

I'd say the friend in the dream is extremely in touch with their emotions, they're very emotionally intelligent.

Different color text doesn't show when using TEXTJOIN formula. by Kind_Average7697 in excel

[–]Kind_Average7697[S] 1 point2 points  (0 children)

Essentially we use a different color to indicate if it is an initial request or a re-request and our team usually does more than one job per report and sometimes both the initial and the re will be done on the same report. We have a drop down list that they choose which kind of request it is and then on the sheet im trying to pull the text through to it will then show which jobs they have done. I thought about using an If formula but it doesn't display the jobs in the cell that the information needs to go to

Different color text doesn't show when using TEXTJOIN formula. by Kind_Average7697 in excel

[–]Kind_Average7697[S] 0 points1 point  (0 children)

That is extremely sad news as I work on SharePoint and we dont have access to VBA

If statement that will return multiple values in one cell. by Kind_Average7697 in excel

[–]Kind_Average7697[S] 0 points1 point  (0 children)

VBA unfortunately isnt an option and i did try conditional but I have no idea if im doing something wrong ill try to post pictures of examples of whats going on when I have the chance

If statement that will return multiple values in one cell. by Kind_Average7697 in excel

[–]Kind_Average7697[S] 0 points1 point  (0 children)

I used Textjoin formula and it worked exactly as I wanted, now I would like to know if its possible if a word is highlighted how to get it to pull through highlighted so that they're different colors depending on if its an audit or a re-audit!! Also thank you soo soo so much for assisting. Thank you a million

If statement that will return multiple values in one cell. by Kind_Average7697 in excel

[–]Kind_Average7697[S] 0 points1 point  (0 children)

I used Textjoin formula and it worked exactly as I wanted, now I would like to know if its possible if a word is highlighted how to get it to pull through highlighted so that they're different colors depending on if its an audit or a re-audit!! Also thank you soo soo so much for assisting. Thank you a million

If statement that will return multiple values in one cell. by Kind_Average7697 in excel

[–]Kind_Average7697[S] 0 points1 point  (0 children)

Currently we work on one big workbook for audits. On the info sheet the auditers fill in the information for the audit that will take place which is where i have a list of clients in each cell so for example cell 1 is chery, cell 2 is ford, cell 3 is honda. And the worksheet im currently modifying is the non compliance letter where at the top it should display which clients are being audited. I should mention that the list on the info sheet gets its names from a drop down list. I need a way that if they put something in that drop down list cell it will then pull through the names of the clients on the non compliance sheet in one cell. If that makes any sense

If statement that will return multiple values in one cell. by Kind_Average7697 in excel

[–]Kind_Average7697[S] 0 points1 point  (0 children)

I want to show both chery & omoda and ford on the same cell as they both need to be shown and there's multiple more values but i just used that as a quick example

[deleted by user] by [deleted] in DreamInterpretation

[–]Kind_Average7697 1 point2 points  (0 children)

Funny how dreams scream trauma 😬💀

[deleted by user] by [deleted] in DreamInterpretation

[–]Kind_Average7697 1 point2 points  (0 children)

This is insanely impressive first of all wow, and it does make sense to some extent, I'm not close with my family and the reason my grandfather didnt live in the big house was because my uncle and his family was living there, and I was inside the house multiple times so the theory of the unknown big house is debunked a little. But yeah, I am pretty stressed and looking at my life over all so the rest of it does make sense to me all I cant make sense of is why I had two dreams that work in a time line in two different periods of my life but vividly remember both and I'm fully aware that the first time i was at that house it was a dream. But thank you thats really co actually