how to build a table vba that will add values like from 1,2,3 to 1,1.5,2 with a given freq

**kashbay** · 09-12-2017, 11:05 AM

how to build a function in vba that will take an input an array of values like from 1,2,3 n give 1,1.5,2,2.5,3 depending on a given frequency.
for example if i what the table to split to semi annual dates it will go from 1-2yrs to 0.5yr, 1yr, 1.5yrs, 2yrs. etc

**oeldere** · 09-12-2017, 01:38 PM

non VBA solution.

e1 =B19

e2 =IF(OR($E1=7,$E1=""),"",MIN($B$20,$E1+$B$18)) and drag down.

**alansidman** · 09-12-2017, 01:45 PM

Here is a macro that I use

Please Login or Register  to view this content.

**kashbay** · 09-12-2017, 01:55 PM

thank you but this isnt what i mean.
so i will input that table into my function and get another table with 0.5 increments. this what i have so far:

Please Login or Register  to view this content.

it runs half gives me a #N/A error

how to build a table vba that will add values like from 1,2,3 to 1,1.5,2 with a given freq

LinkBack

Thread Tools

Rate This Thread

Display

how to build a table vba that will add values like from 1,2,3 to 1,1.5,2 with a given freq

Re: how to build a table vba that will add values like from 1,2,3 to 1,1.5,2 with a given

Re: how to build a table vba that will add values like from 1,2,3 to 1,1.5,2 with a given

Re: how to build a table vba that will add values like from 1,2,3 to 1,1.5,2 with a given

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Build a Ingredient table based on two table

How to build a Loan table with a Pivot Table

how to return top ten values and build a new table without using pivot table

[SOLVED] Freq distribution problem

Add number freq over 10

[SOLVED] Build Table using selected fields from Table of data

2 dimensional array and freq function?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions