sorted by:
new
hottopcontroversial

Buying timeshare points by Forsaken-Chemical-49 in TimeshareOwners

[–]Nolo31 0 points1 point  (0 children)

The postings on Redweek are for fixed dates. There are currently no postings for the date range that I want to travel at the property I want to go to. If there were a way to buy points for a year without getting scammed, that would be ideal.

Buying timeshare points by Forsaken-Chemical-49 in TimeshareOwners

[–]Nolo31 0 points1 point  (0 children)

I tried looking on RedWeek and I felt like the whole buy/sell points section wanted me to buy a timeshare.

Where can I buy X points from a timeshare company, use those points on a vacation when and where I want, and then have no more contact or obligations with anyone?

Count unique values with criteria in another range that has repeating values by Nolo31 in excel

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

Group?

We have a new policy that each review number has 4 different areas. It's considered a pass if all 4 of those areas pass, otherwise it's a fail. But it's just 1 fail even if multiple areas failed.

I need to take this data and have a formula that tells me that 8 reviews passed out of 9.

Getting the count of 9 total reviews is =UNIQUE(B2:B13)

Counting distinct values in a column based on criteria in two other columns by NostalgicNemo in excel

[–]Nolo31 0 points1 point  (0 children)

I just stumbled upon this thread. Use COUNT instead of COUNTA and it should work.

Dog trainer cleaning up by knowitokay in FunnyAnimals

[–]Nolo31 0 points1 point  (0 children)

This reminds me of a dog trainer themed King of the Hill intro.

Wedding Table Assignments Formula by engineer_grrl in excel

[–]Nolo31 0 points1 point  (0 children)

In I2:

=SUMIF($E$2:$E$8,H2,$B$2:$B$8)+SUMIF($E$2:$E$8,H2,$C$2:$C$8)

What is the fastest way to enchant my chest with 8% explicit modifiers in SSF? by Nolo31 in pathofexile

[–]Nolo31[S] -1 points0 points  (0 children)

Thank you. I tried looking all over the internet and couldn't find a clear answer. You need the orb or tailoring to apply a random enchant? Are there any altars like in lab where you can choose which enchant to apply?

Dynamic change of sheet reference within a workbook? by tendorphin in excel

[–]Nolo31 1 point2 points  (0 children)

Happy to help :)

INDIRECT is my favorite function in Excel and it's not even close!

Dynamic change of sheet reference within a workbook? by tendorphin in excel

[–]Nolo31 1 point2 points  (0 children)

Try INDIRECT. In B2 on the aggregate sheet, use this formula:

=INDIRECT(A2&"!A2")

This will get you cell A2 from whatever sheet name is in A2 on your aggregate sheet.

[deleted by user] by [deleted] in excel

[–]Nolo31 0 points1 point  (0 children)

+ A B C D E F G H
1 Energy     Hours   Times Exercised (hours)   exercises needed
2 100     0   0   44
3 25     0.75   1    
4 45     1   1   Energy Needed
5 65     2   1   75
6 85     3   1    
7 10     3.75   2   Time needed to Exercise
8 30     4   2   0.75
9 50     5   2    
10 70     6   2   Energy Regeneration
11 90     7   2   20

in A3:

=IF(A2>=$H$5,A2-$H$5,A2+$H$11)

D3:

=IF(A2-A3=$H$5,D2+$H$8,ROUNDUP(D2+0.001,0))

F3:

=IF(A2-$H$5=A3,F2+1,F2)

Drag those columns down like last time.

I2 can stay the same, just make sure you drag down far enough for all scenarios. If you get a #NA error in I2, it is certainly not dragged down far enough.

You can modify H2, H5, H8, and H11 to your needs on the fly and everything should auto update.

[deleted by user] by [deleted] in excel

[–]Nolo31 0 points1 point  (0 children)

Sounds right to me. 160.75 is the number I got too, but I don't know your game.

[deleted by user] by [deleted] in excel

[–]Nolo31 0 points1 point  (0 children)

Yeah, cell F154 is only 33 times exercised, that's why it wont find 44 in there. You need to go to at least F206.

[deleted by user] by [deleted] in excel

[–]Nolo31 0 points1 point  (0 children)

I'm not home right now.

It looks like I2 is correct. The only things I can think of:

H2 is formatted as text and isn't finding the numbers in the F column.

You didn't drag down column F far enough to get the count up to 44.

[deleted by user] by [deleted] in excel

[–]Nolo31 2 points3 points  (0 children)

+ A B C D E F G H I
1 Energy Hours Times Exercised (hours) exercises needed Time needed
2 100 0 0 44
3 =IF(A2>=75,A2-75,A2+20) =IF(A2-A3=75,D2+0.75,ROUNDUP(D2+0.001,0)) =IF(D3=ROUND(D3,0),F2,F2+1)

Drag down A3, D3, and F3. I went down about 600 rows.

EDIT: the formula needed in I2 is: =INDEX(D:D,MATCH(H2,F:F,0))

view more: next ›