column & row

Hi, I’m a bit of an Excel noob, so I hope I’m able to express myself clearly. Using Office Professional Plus 2019 on a Windows 10 computer. I'm working with a large dataset of TV show transcripts. Column A ('speaker') has the names of the characters, and column B ('line') has the lines they...

Hello excel gurus, I have and excel file with : Sheet 1: Col A data1 data2 <<Empty cell>> Sheet 2: Col A data a data b data c <<Empty cell>> I have some 20+ sheets like "Sheet 1" and "Sheet 2". I would like to have a new sheet (or maybe in another...

Hi all, I am trying to find a column letter based on a text ,contained in a cell. I managed to find the letter, but the next part is what bothers me. The column letter(declared as "trcol") is a part of a loop that goes through the table and copies certain values based on that column.So that...

So I have a very long column of data - several thousand rows most of which = close to 0. Between every 140 and 170 (not the same gap every time!) rows I have between 9 and 11 data points that I need. If I use a data filter I get the information I need but i have no way to convert that into...

Hello there - I keep forgetting how to think about the logic of these functions. I tried to look across my other workbooks for formulas. I feel like I've done this before so I apologize but I couldn't find the formula hence why I"m posting. I've searched and using these links and posts as...