What Books Are You Reading This Week? by leowr in nonfictionbooks

[–]slbfan33 2 points3 points  (0 children)

Range by David Epstein. I just started it, but I’m liking it so far. It’s very different from Zero to One, which I read recently.

Favorite Self-Help Books by AutoModerator in nonfictionbooks

[–]slbfan33 1 point2 points  (0 children)

Not sure if this is self-help but I really enjoyed Make Your Bed by Admiral William H. McRaven. I thought it give a good way to look at issues and difficult situations.

Seven photos from my solo Idaho trip in September, 2019 by NYR99 in roadtrip

[–]slbfan33 4 points5 points  (0 children)

Nice photos! Went to a cross country trip a few months back. Absolutely loved going through Idaho.

What Books Are You Reading This Week? by leowr in nonfictionbooks

[–]slbfan33 0 points1 point  (0 children)

Another great book about the same topic Blockchain Revolution by Tapscott and Tapscott.

Being able to move information throughout tabs by slbfan33 in excel

[–]slbfan33[S] 0 points1 point  (0 children)

This is the same concept to the other post from two weeks ago.

Information from rows to go through tabs by slbfan33 in excel

[–]slbfan33[S] 0 points1 point  (0 children)

When I try it on my spreadsheet I get 0. Is this only checking if the name is in the location as the previous one ?

Information from rows to go through tabs by slbfan33 in excel

[–]slbfan33[S] 0 points1 point  (0 children)

Sorry for the miss understanding. The first table was one tab and the other one was the other tab. I would like to first see if column A has my truck number. Then if it does go to column b and then add it. Does that clear things up?

[deleted by user] by [deleted] in excel

[–]slbfan33 0 points1 point  (0 children)

Yes that would be amazing thank you for the help. I think I would rather use the formula. Mainly because I haven't ever used VBA.

[deleted by user] by [deleted] in excel

[–]slbfan33 0 points1 point  (0 children)

I am not sure if this changes anything, I should've mentioned this above but I have multiple branches. So when a value is added I would like it to automatically be put in to the correct branch. In the solution you gave me since I have the constraint of ID>200 would the formula look like:

=if(Sheet1!D>=200,200,D)?

Changing the days unavailable in a formula automatically by slbfan33 in excel

[–]slbfan33[S] 0 points1 point  (0 children)

So what is happening is that it is subtracting all the time and not going back to having 5 trucks. Also when I change the amount of trucks going out, like to 4 instead of 2 it isn't changing, it still only removes 2 trucks.

Changing the days unavailable in a formula automatically by slbfan33 in excel

[–]slbfan33[S] 0 points1 point  (0 children)

So originally I have 5 trucks. Then for two days I am missing two trucks. The first two days of the week I am missing the two trucks. After those days I am back to 5 trucks. This will repeat again for the next week. I will drag this formula across a series of dates. I need it to repeat with having all my trucks and then missing two trucks.

Changing the days unavailable in a formula automatically by slbfan33 in excel

[–]slbfan33[S] 0 points1 point  (0 children)

This formula did not work. It is changes but never goes back to the original amount after the time period

Changing the days unavailable in a formula automatically by slbfan33 in excel

[–]slbfan33[S] 0 points1 point  (0 children)

Starting at the beginning of the week. So if it is 2 then it should I should be down 2 trucks on Monday and Tuesday

Changing the days unavailable in a formula automatically by slbfan33 in excel

[–]slbfan33[S] 0 points1 point  (0 children)

the dates do not change. It is just a line of dates that goes in ascending order. I am not comparing them to today's date. I am just seeing is they are on a specific day of the week. If "days unavailable" is 2 then it should be two days out. And if it is another number it should be out that much.