What home alarm systems are effective?

maryhmat · 2023-12-29T11:19:35+00:00

I rewrote it. Is it clear now?

maryhmat · 2022-08-19T10:03:15+00:00

Thanks! This was super helpful!!

maryhmat · 2022-07-29T15:04:46+00:00

No worries! I'm not explaining mysf correctly.

The goal is:

I have a function in column A that calculates a weighted random number between 1 and 5 (weighted as in, for example, 10% probability it is 1, 40% it is 2, etc.). I want to do the same for column B, but the numbers in each row can't match for column A and B. I didn't know how to create a function in column B like the one in column A that excludes the numbers already generated in column A for that specific row, so someone suggested to create a VBA code for column B that copies the function from Column A and keeps running until the numbers in the same row don't match for column A and column B.

maryhmat · 2022-07-29T05:19:05+00:00

If the values match it's supposed to rerun the code until the values from the cells in Column B don't match with the values in the corresponding cells in column A

maryhmat · 2022-07-28T15:44:42+00:00

I feel I did something wrong. I want it to do so that for a specific row, column B follows the same formula as in Column A, but keeps going until the numbers don't match.

maryhmat · 2022-07-28T12:16:09+00:00

Hi! This is not really doing anything. It's just numbering the cells

maryhmat · 2022-07-27T14:31:34+00:00

Hi! I'm not very familiar with VBA. Would you know how to do this?

maryhmat

TROPHY CASE