how to do this multiplication of total amount dynamically? i saw the video of finding the sum of values using index in your playlist. but how to add or multiply to colomns dynamically ?
Hi Rakesh! Such a easy trick thank you. Can you please teach us conditional sum , say total of only students above 40 marks and also number of times a city name repeater say " Newyork" . Looking forward to see your amazing videos.
Thanks for your video! I have one more thing if I have n number of rows then how can i sum a total column like you did =sum(B2:B15) . Please help me out
@@AutomatewithRakesh I have tried. It worked. Used like this - "=Sum(V2:V" + num +")", where num is a variable. I thought to share here because it may be helpful for others.
Felt so excited
Solved another problem with your videos, thanks
Great to hear Mike
Always like your videos...
As per video you take multiple write cell but..instead of taking for each loop and how to take the indexof formula and how to add +1 for each row
how to do this multiplication of total amount dynamically? i saw the video of finding the sum of values using index in your playlist. but how to add or multiply to colomns dynamically ?
Hi
Lets assume am not sure how many rows are there but my grand total should be in last row +1. How can we find last row??
how will you access an excel file from shared path while those excel file is accessing by another user??
clear and simple ! thank you
Thank you
💯
Hi Rakesh!
Such a easy trick thank you. Can you please teach us conditional sum , say total of only students above 40 marks and also number of times a city name repeater say " Newyork" .
Looking forward to see your amazing videos.
How to get row index of particular column in UiPath ? Suppose Column 1 has 10 rows & Column 2 has 15 rows and I want to know the Index of Column 2
Hello, at the time 2:53 - why we didn't get B2*C2 everywhere? We got B3*C3.....B4*C4 etc.. I have expected to get B2*C2 in every row.
I would also like to know this.
Thanks for your video! I have one more thing if I have n number of rows then how can i sum a total column like you did =sum(B2:B15) . Please help me out
You need apply the same write cell activity for all N number of rows. The cell where you need to apply the formula
Just a repetition or need to apply the write cell with changing variables
@@AutomatewithRakesh Can you please explain more?
Simply Good... Looking Forward to your Projects on Performer and Dispatcher in Re Frame Work
Sure
Can I use variable in the formula?
You can give it a try
@@AutomatewithRakesh I have tried. It worked. Used like this - "=Sum(V2:V" + num +")", where num is a variable. I thought to share here because it may be helpful for others.
@@nithyasankar42 awesome continue to share
SIR,HOW TO FIND PERCENTANGE ???PLS REPLY SIR
How to choose dynamic range for formula...
why we didn't get B2*C2 everywhere? We got B3*C3.....B4*C4 etc.. I have expected to get B2*C2 in every row.
How to automate freeze excel
IM GETTING #NAME? IN THE TOTAL IN EXCEL SHEET