-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
zigdan420
-
Merge cells of emails into one cell - possible?
Hi all, I have the following setup (albeit in a much larger setting with multiple lines of emails): I want to merge my emails in A121 and A122 into one cell, like I have done above in A120. Is this possible? In reality, I need to do this for about 50-100 rows of emails from column B-T...- Jyggalag
- Thread
- christian røssel duplicate email excel format formula help jonas sværke lil adderall liladderall olzenmedz quizolzen quizzer vba zigdan420
- Replies: 3
- Forum: Excel Questions
-
How to make formula return blank value when cell is empty
Hi all, I have the following formula: The formula checks if the value in column D is located anywhere in sheet 2's values in the array B1:D133. However, when I pull the formula down, it also checks blank cells. Is there any way to edit this formula, so when it checks a blank cell (for...- Jyggalag
- Thread
- christian røssel excel ez røssel ez sverk ezrøssel ezsverk formula help jonas sværke lookup røssel røssele sanoj ekrævs zigdan420
- Replies: 2
- Forum: Excel Questions
-
Formula to check if value is in array not working
Hi all, I have this formula I found online: I have now set the formula to test if my value "test" in cell B2 is located anywhere at all in within the value set B1:D133 in sheet 2. I literally have the value "test" in cell B2, but it does not work: It should return the value "1" if the...- Jyggalag
- Thread
- excel formula help isnumber jonas sværke liladderall match olzenmedz sanoj ekrævs sværke vba zigdan zigdan420
- Replies: 2
- Forum: Excel Questions
