Hi all, I want to sort a pivot based on the options
Example: I have a data contains 3 columns, State_name, Lives (*integer), Coverage (*Percentage values)
I have to create 3 options
2. High to low - Lives
3. Low to High - Coverage
If I choose any of the options my data...
I have two sheets, named:
1. Master Data - This sheet will be updated daily by pasting a system report over the existing data
2. 2022 - I want to calculate some stats from the master data sheet on this sheet
The gist of this is, I need to report on people who leave between 0 and 5...
I'm trying to replace a dropdown menu, whith a cell. The user is going to input the real distance in this cell.
As it's works now, the user select the nearest "visible" distant (there can be several selectables but the one whith the best / longest option is visible)
So this works like this...
Hello, I'm tryin to sort values based on colors, then on values
The macro was working very well, but on one sheet, so I have to create a new module for each sheet, and because I have around 400 sheets,
This is the simple working macro:
' A_Sort Macro
I am trying to make a formula that goes from row to row and left to right to check if the cell is equal to 1. If the cell is equal to 1, then I want to print the number that's below the cell.
I added a picture to illustrate what I mean.
Appreaciate any help I can get. I have been...
Hi there, I’m hoping someone can help me with this question.
I have a series of formula being used to generate unique reference numbers, finishing with CONCATENATE, as seen in the screencap attached. I am using a simple =IF(H60=””,””,ROW()-2) formula to generate the final four digits of the...
I hope I can explain in detail, what I need.
Cell J12 reflects the required date of drawing 101 for PO 123456. For this I used the formula: =IF(ISBLANK($B12),"",$B12+14)
Cell J13 needs to reflect the required date of drawing 102, based on the date drawing 101 was sent back to the...
Can you please help me with the below?
I have 2 columns
I want to define named ranges depending on column A value. For...
I'm struggling with a complex IF formula, hoping someone can help.
In D2 I have a category number 1-4.
In F2 I have a number which could be positive or negative.
I need a formula in G2 to work out the following conditions:
IF F2 is 0, G2 = 0
IF D2 = 1 AND F2 is GREATER than zero MULTIPLY...
I am trying to create a formula that will extract the campaign name that generated the lead in the sheet.
The campaign name column looks like this-
I am trying to create a Formula(s) that will extract the campaign name that generated the lead in the sheet.
I am looking for some assistance with a complex macro. I need to pull in all data in tabs between 'Start' and 'End' in my workbook into one tab called 'journals'. The trick is, I need to pull in all the data from each tab in columns JK:MX. Then I need to stack the data so tab 1...
I've been given a particularly diabolical challenge, and for the life of me, I cannot make it work. The challenge is to execute within a single cell a formula that will calculate "EAC: equivalent annual cost" within a single cell. There are two distinct steps in the calculation; first, one...
So I want to apply a simple formula to calculate closing Balance i.e.
'Closing Balance= Opening balance + purchase - sale'
But there are many complexities.
the main issue is. I have 3 workbooks, Workbook 'O' and Workbook 'T' and Workbook 'CT'
Workbook 'O'- containing Opening balance as on...
I am trying to concatenate a complex string of text and percentages and variances and struggling to get it to work. Can any geniuses out there assist me?
A1 = "Revenue"
A2 = % which could be +/- which is referencing Cell B2, ie -5.3%. Negative figure not required to be pulled through
I have this specific task at work which I failed to do with VBA. So let me explain and even put a link to my file.
I have the below arrays:
Alpha: Includes a lot of Index Code|Exchange Code (Separated by "|")
Beta: Includes a lot of Date| Exchange code (Seprated by "|")