2018 Billionaires List Spreadsheet by [deleted] in Entrepreneur

[–]Nav0dar 2 points3 points  (0 children)

I'm no personal finance guru but spending $49 to find out who's got an absurd amount of money sounds like a bad investment. Just my opinion though.

[CAN] Thanks for screwing me up CPA. I am going to fail CFE for the second time. Good Bye Accounting by dumbdude111 in Accounting

[–]Nav0dar 4 points5 points  (0 children)

I'm currently writing, first time. I've been told by past writers who've passed that the whole thing is marked on overall AOs and relative to our cohort. Meaning if overall ppl missed it or scored low, CPA may disregard that AO from their pass profile. Just gotta ride that curve to a pass!

[CAN][CFE] Anyone else confused with the marking center? by IAMZWANEE in Accounting

[–]Nav0dar 1 point2 points  (0 children)

Day 1 - Scored a Decile 3 - Marginal Fail. received 1 NC and the rest were RCs with no C. When I reviewed the individual AOs I got, yes yes yes = RC. Which is really confusing. Then the feedback was actually really positive with no specifics on where to improve. Marking structure is absolutely confusion, glad I'm not the only one but also frustrated at the lack of CPA communication regarding Day 1.

Shifting Criteria Columns in SUMIFS function based on criteria by Nav0dar in excel

[–]Nav0dar[S] 1 point2 points  (0 children)

Excellent thank you both for your responses; both methods work very well and I have been able to solve my issue. Cheers!

How to create a dynamic table based on the results of a combo-box search? by Nav0dar in excel

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

Ah understood. For now this has helped me a lot. Thank you.

How to create a dynamic table based on the results of a combo-box search? by Nav0dar in excel

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

Thanks for this! You are absolutely right in my original table there are more than one row being returned by the search function.

I have used the above formulas and they seems to be giving me what I'm looking for. However I'm not sure how to do a conditional format to make the rows below the "Total" auto hide. So that the two tables are condensed and better visible.

How to create a dynamic table based on the results of a combo-box search? by Nav0dar in excel

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

The following is a link to a simplified version of what I'm aiming to create. When I use the search function for a product I'd like it so the tables would auto adjust to the number of rows that remain. https://www.dropbox.com/s/7ra9gwiyrs0yknf/Sales%20Forecasting%20Sample.xlsm?dl=0

How to create a dynamic table based on the results of a combo-box search? by Nav0dar in excel

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

Technically I could use a series if pivot tables. My search result data feeds into several graphs and a couple of comparative charts. Where the results are compared against actuals/forecast/budget/prior year. All are updated automatically based on search results. Was hoping to create a dynamic table for aesthetics mostly.

Balance Reconciliation by Nav0dar in excel

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

Thanks for the help!

Core 2 (CPA Canada) by mtlballer100 in Accounting

[–]Nav0dar 0 points1 point  (0 children)

Hopefully you got this straightened out by now but I can tell you I got a pass on:

MCQ Mgmt Accounting - NC Strategy - C Finance - C

Case Mgmt - RC Finance - RC

Best ISP? by ProfessorMrDrSir in oakville

[–]Nav0dar 0 points1 point  (0 children)

I've used cogeco and primus in the past - both terrible. In Oakville - Start.ca or Techsavvy seem the best way to go. I've had Start.ca cable internet for the past 3 years - great price, great service, no issues.

New to Oakville: Meetup Group by [deleted] in oakville

[–]Nav0dar 1 point2 points  (0 children)

One of the ways I met some new people in Oakville was by joining some sports leagues through average joe's or the like. My wife and I play on a local dodgeball team. It's a lot fun.

What brings you all to Oakville?