Relative Content

Tag Archive for excelvbaexcel-formula

compile error : Ambiguous name detected: Worksheet_Change [duplicate]

This question already has answers here: Multiple Worksheet_Change events in VBA code (4 answers) Have more than one Worksheet_Change in a Worksheet (2 answers) Closed last month. I was using VBA code for Timestamp And move row to another worksheet. I was using Below codes successfully working individually, but two codes entered in worksheet module […]

Automatically add timestamp to a cell if another cell has any text in it

I need Excel to add a time stamp to a cell (Let’s say D1) if another cell (Let’s say A1) have any text entered into it. We have a PC setup that we will scan items using a hand scanner set up as a keyboard in our storage as either “IN ” or “OUT “. When an item is scanned into cell A1 the timestamp will automatically be inserted into cell D1. Is there a formula for it, or do I need to set a macro using VB.

How to pass the result of an array formula to a custom function?

I have a custom function which calculates linearly interpolated values with a specific base value, accounting for that base value and reducing the total to be the same as if the base value was 0. I calculate its t value inside the argument parentheses, and this seems to be the issue.

How to pass the result of an array formula to a custom function?

I have a custom function which calculates linearly interpolated values with a specific base value, accounting for that base value and reducing the total to be the same as if the base value was 0. I calculate its t value inside the argument parentheses, and this seems to be the issue.

How to pass the result of an array formula to a custom function?

I have a custom function which calculates linearly interpolated values with a specific base value, accounting for that base value and reducing the total to be the same as if the base value was 0. I calculate its t value inside the argument parentheses, and this seems to be the issue.

How can I find the correlation of items sold in Excel?

I have a data set of sales of a supermarket. The first column is the ticket number, the second column is the code of the item sold and the third column is the name of the item. How can I calculate the correlation of the items. For example, if I sell a cup of coffee, 60% of the time in the same ticket will be a cookie present.