Sole

Last seen: 4 years ago | Active since 2020

Followers: 0 Following: 0

Question

How to read an excel table and limiting its size (# of rows) to only the data entries
Hi, I have a table with data filled in from 57 rows and 15 colums. How do I limit the size to 57 by 15 when reading it and be a...

4 years ago | 1 answer | 0

answer

Question

Filling out an empty column in an existing table based on conditions matching other columns
I have a table. If column 3 is "fast" AND column 4 contains any of these characters: boat, car, or airplane. then column 5 beco...

4 years ago | 1 answer | 0

answer

Question

Producing strings in empty column based on strings on another column
I have a spreadsheet with a blank column (57x1) that I want filled out based on the strings on another column (57x1). Basicall...

4 years ago | 1 answer | 0

answer

Question

Copying and pasting data from one excel worksheet to another or from the workspace to an existing worksheet
I have a macro enabled excel workbook with multiple sheets. Without creating a new workbook, how do I copy data from one existin...

4 years ago | 1 answer | 0

answer

Question

Sort unique string/number column based on last 2 characters
How do I sort a column based on the last 2 characters while maintaining the unique string/number order? I want each group of uni...

4 years ago | 1 answer | 0

answer

Thankful Level 2