“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I need to repeat y axis on opposite side of the stack area plot for easy readability. How can I do it?

Solved by A. E. in 14 mins

concatenate help for large amount of data

Solved by F. J. in 29 mins

I recently exported a bibliography from word into excel via text. The titles, all between and have varying lengths therefore diffent columns. Using concatenate how can I make a formula that only concatenates between cells where appears, i.e.a concatenate formula of varying columns?

Solved by T. Q. in 28 mins

Could you please explain what is being referenced in the follow string? I am familiar with using INDIRECT and CONCATENATE together. =INDIRECT(CONCATENATE("'Sheet Name'!",K$1&$A6))

Solved by B. L. in 24 mins

I need a formula to reverse distance in feet between several segments e.g 0,1000,4500,10000.........reverse the same the opposite way calculating the distance between 10000,4500,1000,0

Solved by V. Y. in 13 mins