by B Chen
Last Updated September 14, 2018 16:01 PM

Not a coder so until I learn how to run a simple script that can do the job, I am hoping Excel VBA/Macro can help make my job easier. Below is the task and I wonder if VBA/Macro is capable of doing it.

11292 rows of item (e.g., individuals), categorized in 33 groups (e.g. ethnicity). Groups vary in sizes. Within each group, I need to calculate the fold difference of a measured value (e.g., salary) from the lowest to the highest. There are 10 different "measurements" for the total dataset (e.g., "salary" and "monthly grocery expenses" as two "measurements").

The current workflow is as follows 1. using Excel, I sort 11292 rows of data based on group and then value. 2. I manually limit my calculation within the same group, set the lowest value in the group as 1 and calculate the fold change for the rest of the group 3. repeat the same calculation for the next group (32 repeats)

Although the process seems iterative, a few challenges exist to automate the process (in my mind) 1. VBA/Macro needs to "identify" the groups and restrict its calculation within each group 2. VBA/Macro needs to "identify" the lowest value in each group and calculate the fold change accordingly.

Is VBA/Macro a good tool (for a non-coder) to handle this task?

Thanks

- Serverfault Help
- Superuser Help
- Ubuntu Help
- Webapps Help
- Webmasters Help
- Programmers Help
- Dba Help
- Drupal Help
- Wordpress Help
- Magento Help
- Joomla Help
- Android Help
- Apple Help
- Game Help
- Gaming Help
- Blender Help
- Ux Help
- Cooking Help
- Photo Help
- Stats Help
- Math Help
- Diy Help
- Gis Help
- Tex Help
- Meta Help
- Electronics Help
- Stackoverflow Help
- Bitcoin Help
- Ethereum Help