Search results

I have a fairly standard worksheet that records data by week ending date. it is currently in date order starting with oldest date first going to current date. I need to flip the spreadsheet so it is in date order going from current date down to oldest date. there are 52 weeks listed and some...

WOW, feel like a dummy:-) Thank you so much. I have all of Chandoo's classes on video and now need to sit down and go through all of them. I did some but got busy. Also very excited about the new Vitamin XL.

they are already in a spreadsheet that list each apt number and the bedroom next to it, see below for example Col A Col B 101 A 101 B 102 A 102 B 102 C When we do the original set up we combine them from the start as we will pull the data off of the bldg plans. When we...

I have a long column of data that is a list of apartment numbers, i.e 101, 201,202, etc. and another column that is either A, B, C, or D (indicates which bedroom in the partment). I know how to split data from one column into two however I can't seem to figure out how to add my bedroom letter...

Thank you so much. I obviously need to go back through your classes:-) In fact I am anxiously awaiting the roll out of Vitamin XL.

I have two worksheets both of which have last name and first name of residents. one worksheet has the delinquency/prepaid amount and I need to do a lookup by name and bring the delinquency/prepaid amount into the the second worksheet. The lastname is in the first column in both worksheets...

I didn't realize that. Wonderful. Thank you again, you have been a great help and also inspired me to go back to my Chandoo training videos for review.

Luke, as i work on the other properties the variances are different on each one. what would be the best way to make the lookup table a range so that I could set up one template for all of the properties. something like $20-$25, $26-$30, etc. you have been so much help and I really appreciate...

Thank you I will try this and see what happens.

Luke, still having a problem, can you take a look for me. thank you

Okay, I guess I am worse off than I thought as I am still having trouble. i have a mini spreadsheet set up below with my columns that are affected. I am still making some kind of stupid mistake. can you do the formula for me so I can see where I am going wrong. thank you so much. the rows...

Thank you. I knew it was something simple and my brain just quit working last night. Thank you so much.

I am trying to work on rent increases that are set in 3 tiers. the 2nd and 3rd tier are working great as they are very simple calculations. however on the 1st tier the increase is variable depending the variance between current rent and proposed rent. if current is higher than proposed the...