How do I track days/months since data has been inputted in a specific row then say after 3 month it changes special text in a cell to name-Inactive
I have like 0 vba knowledge beyond knowing how to input the code to use
Excel(VBA) Formula in added column needing logical workaround
I have a table similar to the one below, apart from its about 600 rows long:
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.
EXCEL: How to extract a selection of data from a chart, based on filtered name
I am looking for help regarding a tool I’m creating in Microsoft Excel.
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.
Find a value and then return array below it until the criteria isn’t met
I have a table that contains transactions made by each of my projects.
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.