Comments for Spreadsheet Point

Comment on A Google Sheets Sort by Multiple Columns Guide (2 Easy Ways) by jmarkus

jmarkus — Thu, 02 Jan 2025 12:06:58 +0000

In reply to bob. 100%

Comment on A Google Sheets Sort by Multiple Columns Guide (2 Easy Ways) by jmarkus

jmarkus — Thu, 02 Jan 2025 12:06:34 +0000

In reply to Scott. Your multi-column sort should be saved as long as you have edit access to the sheet.

Comment on A Google Sheets Sort by Multiple Columns Guide (2 Easy Ways) by jmarkus

jmarkus — Thu, 02 Jan 2025 12:06:06 +0000

In reply to Al. No, the sorting will affect everything. The idea with this guide is that you want to sort by a single column first, then by another column. The whole dataset is sorted, not just the column.

Comment on A Google Sheets Sort by Multiple Columns Guide (2 Easy Ways) by Al

Al — Tue, 31 Dec 2024 18:12:52 +0000

Are you saying that if I sort, say, a 10 column spreadsheet in various ways, multiple times selecting just three columns for the sort, all the row data across the other 7 columns will not be sorted along with the row data in the three columns thus losing the connection between the data in the three columns and the associated data in the other seven columns? Wow, that would be a disaster for a large spreadsheet. How would you ever get it back to the original state?

Comment on Google Sheets vs Excel – Which Is Better In 2025? by Kama

Kama — Mon, 16 Dec 2024 08:38:38 +0000

In reply to Jagannathan.

Thanks for that. I have used Excel for years and when I had to use Google Sheets at a recent placement, I struggled intensely. My manager claimed they had same functionality. They absolutely don’t. I wasted so much time YouTubing and Googling how to do basic things or where function keys/buttons were. The only thing I appreciated about Google Sheets was the ease of sharig and collaboration and auto-save. I believe the latter is also now available on Excel, but you have to activate it.
Thanks for highlighting the lack of sheet protection on Google Sheets. It was a function I used frequently in my line of work.
I’m still an Excel fan, but here to look for something with better collaboration and sharing option for personal use.

Comment on How To Highlight Duplicates in Google Sheets by Sheenu

Sheenu — Tue, 10 Dec 2024 07:19:57 +0000

the guide on spreadsheet Point provides a clear and easy-to-follow method for highlighting duplicates in Google Sheets, making data management more efficient.

Comment on How to Divide in Google Sheets (Numbers, Cells, or Columns) by jmarkus

jmarkus — Fri, 25 Oct 2024 11:14:04 +0000

In reply to m. Great question. Yes, you can use =DIVIDE(A1, 12) and it should work just fine.

Comment on How to Divide in Google Sheets (Numbers, Cells, or Columns) by m

Thu, 24 Oct 2024 19:58:00 +0000

Is there anyway you can use the function without having a cell for the divisor? If i have a cell with a total but I want to divide it by 12 months, do i have to create a cell that says 12 for the function to work? Or can i =DIVIDE(Cell#/12) some how??

Comment on Google Sheets Conditional Formatting Based on Another Cell by jmarkus

jmarkus — Mon, 23 Sep 2024 11:17:01 +0000

In reply to Anke. The dollar sign in that formula is already set up so you can click/drag it across the whole row. The "B" part will stay the same while the 2 or 3 will update as you drag it. So you don't have to manually rewrite it.

Comment on Google Sheets Conditional Formatting Based on Another Cell by Anke

Anke — Mon, 23 Sep 2024 08:39:57 +0000

What’s the formula for “if previous cell is lower in value”
e.g. if B2 mark red
if I understand correctly this would be
=$B2<$B3
but how do I expand to the whole row so I don't have to rewrite every cell ?