Search results

Hi @p45cal was able to get my Power Pivot add in working. Thanks for your patience....

I was trying to work this formula in my set of files that were attached in this post. Let me try again....

@p45cal I am using office 365 here in data ribbon the data model is not working

Can you please send me the data model file that you worked on. I am getting error on using this formula in the power query editor while adding a custom column in ContractNoteDetails

Hi, The column is what I want. Please share with me how you added this column in one of the tables in the query. This is my first attempt at using power query. Thanks @p45cal...

I have data as two tables in NFO_Contract_Note.xlsx . Table8 is related to ContractNoteDetails on the date field. I have done the get and transform data on these two tables. In the final pivot report I need Date, Obligation Pay In/ Pay Out, Brokerage & Exchange Fee & Taxes and a column that is...

On further use if this VBA I observed something strange. If you run this on three different columns for 10 rows starting at same date, the results on previous columns change.. Perhaps you could figure it out...It is beyond me!

Wow it worked like Magic! Thanks @AlanSidman.

Thanks @AlanSidman. Never used VBA let me get a handle on where to put this code. I will post an update ASAP.

I am maintaining a journal in which data is logged on daily basis. In the first column [A] I want to auto fill with date starting from the first date in A5. The auto fill with date as series does the fill. However the dates for the weekends that is Saturday Sunday is not required. How to remove...

Yes FIFO is a complex thing. The first file seen by you is modeled along lines of a protected workbook(FIFOComplete.xls), work of a Thai gentleman. I have sent a Mail to him I am awaiting a response.I am attaching that file, see if you can understand the data table part of the worksheet. Data...

Thanks Bosco. I have created a workbook with a sheet on your guideline. It is attached. When I add another share id, the calculation of cost of shares sold includes the purchase price of the first share id. The calculation need to be on the share id specific. To get a balance shares for each...

The File has some corrections done. Please use this file.

Thanks to Peter and Nebu to have taken time out to help me. I have implemented peters option 1. With this the FIFO appears to be working. Value of Cost of shares sold in the outward table needs to be done via what if analysis>Data Table method. I am selecting range P6:Q49 and in what if analysis...

Hi , In the file attached which I am trying to implement Cost of shares sold based on FIFO. Formula in M6 is displaying the correct value. But formula in M7 and M8 are displaying the same value as in M6. If we select M7 and then click Fx in formula bar the result displayed is correct but it...

I will give it a try. How do I change the table to a range.

@pecoflyer Is it a good idea to leave out calculations in a table? Is it possible to get calculated fiels in a Pivot table based on this table (without the calculated columns)?

I do not want formulas that appear on a new row in columns E and H

I have a table that is attached. When a new row is added formulae with values automatically appear in two rows where data has to be entered. I have tried my best that this does not happen but it does. In the entire columns there is no such formula that Control F could find other than on the...

Thanks Chihiro. I have followed and am practising get & transform. I am looking for websites that host the data i’m looking for.

Hello. I need to get the latest value of stock quotes traded in indian markets in my table. I have a trading account on icicidirect.com that can be accessed with password and there is a page that has these values. How to get these into excel. I am using Excel 2016. Best Regards. Karanbir

Thanks sir, i will try it and let you know.

Dear All, I am attaching a workbook that has pivot tables in the worksheets. In the pivot table of sheet 2 the data pertains to previous years. How can I modify the Pivot table so that I can select the financial year for eg. April 2013 to March 2014. Regards K S Soin

Thanks Faseeh. Regards

Oops! I am attaching a file. Regards