Hi Guys,
Can you please be with the following issue?
I have the figures in the format presented in the image and I what to transpose them as in the next columns.
Thanks
Hi Guys,
Can you please be with the following issue?
I have the figures in the format presented in the image and I what to transpose them as in the next columns.
Thanks
Last edited by AlinT; 01-30-2020 at 12:35 PM.
Administrative note
Welcome to the forum
missed the yellow banner advising how to get answers faster by posting a sheet ?
Please take a moment to read it and attach a sheet accordingly.
Thanks you for helping us help you
Are you just looking to get the sums of Premium, IBNR UEPER comm etc etc into the corresponding column?
If so just use a sumif formula.
=SUMIF(I:I,N1,J:J)
where column I is the first yellow column, N1 is 1. Premium and column J is the second yellow column. Adjust as necessary
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
See option with formulaFormula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks