Previous Topic Next Topic

Sorting table without messing up formulas

Closed
Matpi - Sep 24, 2021 at 02:15 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 27, 2021 at 12:07 PM
Hello,
I'm trying to create an excel file to manage my diet and meal plan and counting macros.
I have in the same file a table filled with different kinds of food and their macros beside each one.
Then I use this table to calculate kcal and macros of what I eat using ie. =Cell1*Cell2, where cell2 contains data from the table.
The problem with this is that whenever I sort the table Cell2 doesn't contain the same data anymore and gives me a wrong result.
What could I do?



System Configuration: Windows / Firefox 92.0
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Sep 27, 2021 at 12:07 PM
Hi Matpi,

Could you show us how your sheet looks, to find a suitable workaround for your issue?

You can use screenshots or upload your workbook to a free filesharing site like wetransfer.com and then post back the download link (always be careful with sensitive data). In case of screenshots, also let us know which cells contain formula's and what formula's you use.

Best regards,
Trowa

Similar discussions

Anyone's dm order all weird ?
Tillyleon111 -
toogleeful -

Hey everyone I hope you can help me

So the last 4 days my instagram weirdly changed...

I normally use my instagram by sending dms of memes and videos to my best friends

Normally they are at the top of the list to share with them but now they have all disappeared and I have to search for them all individually.

And some of them now don't even come up with some private pages even though they are apart of that page ?

Any suggestions on how to get then back on the top of my send list.

Cheers everyone

2 responses
Why is my Whatsapp Chat not sorted chronologically?
Kingtt -
Yeraldocaleb -

Previously when I used to delete a message from a chat, whatsapp automatically use to resort the chat list according to date. but now when I delete a message, it does not change the chat list by date. For example, if someone messaged me last month and then again today, if I delete todays message, his chat will not move down to last month. In fact, it will remain on top of the list with last month date on the right.

Does anyone know how to fix this issue?

15 responses
Instagram comment section in chronological order help me
emilioj_88 -
HelpiOS -

Since 2 months in my account the comment section of others posts are in cronological order, i tried everything like unistalling the app, deleting the cache/data, using it in another devices like the PC and nothing works. Also i don't get a response from Instagram and i don't find the solution in Instagram help page. The problem is that it looks that only happened to me cause all my friends and family have the normal comment section (most liked comments first)

3 responses