User Profile
Eladnoam2
Copper Contributor
Joined Aug 25, 2021
User Widgets
Recent Discussions
- 1.7KViews0likes0Comments
Re: merging cells
Riny_van_Eekelen, yes, thats what I meant, even worse, the Excel close down because of the load. I attached file, my file is much bigger, i have 7 columns, with much more data. in the file, i put the formula of @Hans Vogelaar only at the first 100 rows, and its take a minute to end the action. thank you so much! soory about my bad English3.1KViews0likes2CommentsRe: merging cells
hi HansVogelaar i have many rows (950,000 rows). and when i put thw formula that u made, the Excel course from the load. many of my cells (for example, the Animal, and not the Number) are empty. there for i want that the formula get action only in non-empty cells. i tried somthing in the file below (red font), but its worng. (i thought to use in if statment...) ty so much!3.2KViews0likes5CommentsRe: merging cells
HansVogelaar ty! hope that its the last one... i have a table of 950,000 rows. i want that the function play only on non empty cell. I thought... =IF($A$2:$A$11<>"",TEXTJOIN(",",TRUE,UNIQUE(IF($C$2:$C$11=$F2,$A$2:$A$11&"",""))),"") but its not work... any idea? TY!!3.2KViews0likes7Comments- 3.1KViews0likes0Comments
Re: merging cells
hi, i dont want to get a duplicate value, fo example: i have a long table like this: phone animal food 123 dog 123 dog 123 fish 123 pizza 123 hot dog 123 pizza and i want a result like this: phone animal food 123 dog,fish pizza,hot dog and not like this: phone animal food 123 dog,dog,fish pizza,hot dog,pizza ty so much!!3.2KViews0likes10Comments- 3.2KViews0likes0Comments
merging cells
i have a long table like this: phone animal food 123 dog 123 cat 123 fish 123 pizza 123 123 hot dog 456 456 cat 789 fish pizza 789 hot dog and i want a result like this: phone animal food 123 dog,cat,fish pizza,hot dog 456 cat 789 fish pizza,hot dog ty!!Solved3.9KViews0likes13Comments- 1.6KViews0likes0Comments
- 1.7KViews0likes0Comments
lookup to array in one cell
hi, i have a array in one cell, like this: dog,cat,fish and i have a table of prices, like this: dog - 1 cat - 2 fish -3 i want to get a formula that sum all the array, 1+2+3=6. i can split the array to many cells, and do lookup and sum, but i have long array... help!! tY!Solved1.9KViews0likes7Comments
Recent Blog Articles
No content to show