-
08-21-2014, 10:45 AM #41Originally Posted by jesse4466
-
08-21-2014, 11:34 AM #42Originally Posted by Mp859
-
08-21-2014, 11:47 AM #43Originally Posted by jesse4466
-
09-21-2014, 02:21 PM #44
I'm having trouble working the meals.. i can't figure out how to get the items that i have as meal 1 deleted and the list back up? i tried deleting to quantities but the banana and apples act are still in tan and on the page. maybe I'm over thinking this
-
09-21-2014, 02:27 PM #45
-
09-21-2014, 02:37 PM #46
I have a ok knowledge and I just clicked the box hit delete i didn't delete the formats or anything like that. but now all the items you have in that pick are there and no values. does it revert to the list where all the items to select from are green? like i have in meal 7 tab?
-
09-21-2014, 02:47 PM #47
-
09-21-2014, 02:49 PM #48
learn more how to use filters here
Filter data in a range or table - Excel
How to Use Filters in Microsoft Excel | eHow
-
09-21-2014, 02:52 PM #49
had to go to data and select filter from menu bar. I'm using a mac so it might have got lost in translation..it's working now and i appreciate the help, hope the backs doing better today.
-
09-21-2014, 02:55 PM #50
so everything working ok on the calc?
good. let me know if any other q's.
-
09-21-2014, 03:12 PM #51
yes sir just got done clearing out all the daily totals and getting it set up for my fatness… sláinte -John
-
10-13-2014, 10:38 PM #52
anyone here excel proficient and has the time to show some how to insert rows so food can be added?
-
10-14-2014, 04:51 AM #53
Put the courser between the two numbers or letters you want to add the row or cell, Right click, insert.
-
10-14-2014, 07:59 AM #54
I'm trying to have each tab a copy of all the others. there is a global way of doing this, by highlighting all the meals tabs, the doing work on one tab and all tabs will update. but if not excel savy, highly prone to fvcking up. I was getting hit up on a few PM's on how to do certain excel functions, more basic excel skills. I barely have time to come here in the AM and maybe an hour or so in the PM, not like it used to be when on permenant vacation between projects. So I was hoping someone could step up and help out with some basic excel questions when they come up. I can refer the pm'ers to come here and ask.
-
10-14-2014, 10:38 AM #55
Excel use to be easier in a lot of ways. I took a couple excellent classes back in the day when I was getting my computer science degree.
-
10-15-2014, 07:55 AM #56
I always considered myself an excel guru. helped pay my way through college creating excel models for companies. the formulas keep getting better. but then fvcking MS decided that after 97, they would change up things, and now many accountants have devolved to a certain extent trying to remember where shit is found. That was a huge bone head decision by MS to move around where functionality is located. Most accountants (the good ones) "think" in excel and can put together complex formulas almost as fast as they can type.
the one I used to be great at pre Y2K was Access. But most companies don't use, so it's been years, and now skill set is pretty rusty
-
10-15-2014, 10:59 AM #57
Exactly. That's what I am saying. Pre 2000 it was easy to make fields and calculations then they changed it and nothing worked right.
-
10-16-2014, 07:46 AM #58
it still works the same. but now you have to hunt down where they put the shit. I debug a lot of spreadsheets made/used by others, and the "trace dependents/precedents" audit feature seems to keep moving around. This feature also helps debug circular references.
-
10-31-2014, 08:01 AM #59
Thread Information
Users Browsing this Thread
There are currently 6 users browsing this thread. (0 members and 6 guests)
body weight
10-12-2024, 12:06 AM in ANABOLIC STEROIDS - QUESTIONS & ANSWERS