Creating an dynamic array from 3 parameters

philou54520

New Member
Joined
May 25, 2018
Messages
8
Hi all,

I am really a beginner and a little bit ashamed because I could not find after extensive search how to generate a simple array (One dimension) but depending on 3 parameters. I would like to create a serial dilution array where the inputs are: Concentration of stock solution, dilutional factor and number of dilutions. Easy right? I can't manage to do this.

For example:
Stock solution concentration: 5000
Dilutional factor: 2
Number of dilutions: 7

Should generate an array like this:
{5000, 2500, 1250, 625, 312.5, 156.25, 78.125, 39.0625}

Thanks for your help!

Phil
 
Basically it is just for generating a template for ELISA tests (which are used in biology). I would like the members of my lab to use the same EXCEL templates they just have to enter the stock solution and not doing inefficient repetitive tasks
That doesn't really answer my question.
What is the layout of your worksheet like?
What is the underlying data?
Where should this generated 'array' go or how should it be used?

Could you show us a small sample (dummy data) of what your worksheet looks like & include the expected results? My signature block below has a link with suggestions for how to do that so we can copy/paste the sample data to test with.
 
Last edited:
Upvote 0

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
That doesn't really answer my question.
What is the layout of your worksheet like?
What is the underlying data?
Where should this generated 'array' go or how should it be used?

Could you show us a small sample (dummy data) of what your worksheet looks like & include the expected results? My signature block below has a link with suggestions for how to do that so we can copy/paste the sample data to test with.

I can't manage to upload a screen shot. It doesn't work with dropbox. As I said before, it is a very basic function I just want the people to put their initial concentration and it will do math for them. that's it
 
Upvote 0
.. it is a very basic function ..
It may be, but we, who know nothing about what your worksheet looks like or how you want the results displayed, need to understand it before we can help. :)
Perhaps we are being confused by the word "array", which can be interpreted more than one way with Excel. Do you just want the results displayed individually in a number of separate cells?


It doesn't work with dropbox.
What doesn't work with dropbox?
 
Upvote 0
YES I do.
In that case, would this suffice?
Formula in B4, copied down

Excel Workbook
AB
1Stock solution concentration5000
2Dilutional factor2
3Number of dilutions7
45000
52500
61250
7625
8312.5
9156.25
1078.125
1139.0625
12
Dilution



I can't share the image link with the dropbox link
What I was suggesting, like the screen shot in this post, has nothing to do with dropbox. :confused:
 
Last edited:
Upvote 0
In that case, would this suffice?
Formula in B4, copied down

Dilution

AB
1Stock solution concentration5000
2Dilutional factor2
3Number of dilutions7
4 5000
5 2500
6 1250
7 625
8 312.5
9 156.25
10 78.125
11 39.0625
12

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:214px;"><col style="width:56px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas
CellFormula
B4=IF(ROWS(B$4:B4)>B$3+1,"",B$1/B$2^(ROWS(B$4:B4)-1))

<tbody>
</tbody>

<tbody>
</tbody>

Yeah!! sure that's it! as simple as that! Thank you very much for your help! Finally, I assume that array (matrix) was not the right choice then!

Thx
 
Upvote 0

Forum statistics

Threads
1,213,568
Messages
6,114,348
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top