Hello,
Is there any formula that could help me automatically sum y and x values and then return values in white? In a result I need two seperate columns.
Thank you.
Hello,
Is there any formula that could help me automatically sum y and x values and then return values in white? In a result I need two seperate columns.
Thank you.
Last edited by gduobaite; 11-03-2020 at 11:13 AM.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
As you are new here I will add it for you. Please read forum rules
https://www.mrexcel.com/board/thread...alues.1150136/
Thank you!
I will be more careful next time..
A picture is worth 1000 words, a sample sheet is worth 1000 pictures!!
You have attached a non-editable picture of an Excel sheet. That's not very easy to work with. Also... I'm lazy. I have to re-type your information before I can begin to address your problem. That puts me off completely.
So.... Do yourself a favour and please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough). However, please give us an indication of the approximate number of rows of data you want the solution to work with (100, 1000, 100,000 or whatever).
Unfortunately the attachment icon doesn't work at the moment. So,... instead click on Go Advanced (below the Edit Window) while composing your reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.
Make sure confidential information is removed first!!!!
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Sorry sorry sorry...
Now I added small workbook into my primary message.
"However, please give us an indication of the approximate number of rows of data you want the solution to work with (100, 1000, 100,000 or whatever)." – In all, there would be ~40 rows.
=index($c$3:$k$5,match(left(m2,3)*1,$b$3:$b$5,0),match(("0.0"&right(m2))*1,$c$2:$k$2,0))
I don't get LEFT(M2,3) part. You choose M2, but originally I don't have such table, only the B2;K5.
Is there a reason why there is no 0.100 in column M??
Assuming it's a goof-up...
M2:
=IFERROR(INDEX($C$2:$K$2,,1+MOD((ROWS($1:1)-1),9))+INDEX($B$3:$B$5,1+INT((ROWS($1:1)-1)/9)),"")
N2:
=IF(M2="","",INDEX($C$3:$K$5,1+INT((ROWS($1:1)-1)/9),1+MOD((ROWS($1:1)-1),9)))
both copied down.
Yes, it is perfect.
But now I face the issues that I have additional 0,9 column and then its stopped to calculate. I tried to make a change in formula to adapt, but without success.
adjust the ranges of the formula to coer your dataset and adjust the 2 9s in each formula to 10s (as there are now 10 columns to transpose).
See sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks