condiational

CLIENT SALES DATA CLIENTS DATE SALES AMOUNT CLIENT 4 10-Feb-24 819 CLIENT 4 10-Feb-24 326 CLIENT 4 10-Feb-24 952 CLIENT 3 10-Feb-24 210 CLIENT 3 10-Feb-24 820 CLIENT 3 10-Feb-24 809 CLIENT 3 10-Feb-24 298 CLIENT 2 10-Feb-24 728 CLIENT 2 10-Feb-24 772 CLIENT 2...

Hello Excel Gurus, I have sheet 1: Date Invoiced Name Date Planned Include in report Location 01-Aug-23 Event 1 01-Dec-23 Yes New York 01-Sep-23 Event 2 12-Dec-23 No Las Vegas & sheet 2: Date Invoiced Name Description Date Planned Include in report Location...

I have a column that contains lists of dates. How do I remove dates from those lists where value does not = x?

I am making an index of a large number of files with a very long path, and I need that for each "/" each cell moves to the right. That is, if there are 3 "/" in a cell, that same cell must be moved 3 times to the right. is there a way to apply this to all my excel sheet? All help is welcome.

I have couple of Cells Range A1:A12 that calculate percentage. I would like to set up a rule that if percentage in those cells is between 3% and 5% Msg box appears. I am trying following code: Private Sub Worksheet_Calculate() If Range("A1:A12").Value > 3% And Range("A1:A12").Value <= 5% Then...

Context: I am trying to set up a library of plants in Excel that I can select and see their state throughout the year, so I know what plants to add to make a good-looking garden. The moment I press the button, that I included in the Master sheet, I want the Master sheet to show the plants I...

Hi everyone, I don't think I can explain what I'm looking for, but I will do my best. CRITERIA: If Cell A1 equals 1 of 50 states AND Cell A2 equals 1 of 3 Worker Categories AND Cell A3 equals a 1 of 2 FLSA types AND Cell A4 equals a 1 of 200 jobs THEN A5 equals 1 of 7 Pay Classes Example...

I am having a column RawData and want to create another column Results containing a specific data from RawData RawDate Result C/O Paris Based on Sales Order 235987 AR Invoice 25634 Based on Sales Order 235987 AR Invoice 2593 Based on Sales Order 235988 New York and - Holldand Based on...

Can you people help me with below query using a VBA code or excel formula (if it is feasible and doestn't take time). I have data in sheet1 where there is ID in column "A" and category in Column "B". category will have multiple text separated by commas. Possible categories are - Production...

Hi there, I am trying to return one value from a list of values where this list will be growing in the future. So the spreadsheet looks like something as below Where column D will grow in the future. The issue I found so far is that the SEARCH formula only looks for one row at a time. Using...

Hi. I have data in range from Columns G to R. I have value "a" at column J and then 2 Empty Columns. After them I have data at column M and formula give me value "d" but I want to be "b". Also for Column Q, I have "h" but I want "c". If I have Data, this is my formula at Column M( change Column...

Column A / Column B // Column C 0 / 0.1 // (1) 0 / -0.1 // (2) 0 / 0.1 // (3) 0 / -0.1 // (4) 0 / 0.1 // (5) -0.1 / 0 // (1) 0.1 / 0 // (2) 0.1 / 0 // (1) 0.7 / 0 // -0.1 / 0.5 // Rule: 1) Starting value is...

I am trying to highlight rows in if the values in column C and D contain an exact value from column ‘N’. The Values in column are like below: R1179555 R1180259 R1789852 So, if any rows in column C or D contain any of the exact values in column ‘N’ highlight the row. For example: Value...

Need to apply conditional formatting to a cell containing a date e.g L6 = (08/06/2019) Criteria are: If L6 is 2 months or less away from todays date & If M6 is Blank then L6 should be filled red. If L6 is 1 month or less away from todays date & If M6 is Blank then L6 should be...

Hello. In columns Z-AB (Z3:AB800) I have a list of different towns (column Z), customer names (column AA) and buying price for each customer column AB. After a while I'm getting a new list but with similar names and towns in columns AD-AF (AD3:AF800). First I need to compare columns for...

Hi, I'm after some help please. I have 4 columns with amounts and #N/A in them and a column next to in showing the Min. I want to highlight the Min amount from those 4 columns. Column K to N is where I want to highlight the Min --- column O is the Min...

I have a single document that has individuals personal information (first name, last name, demographics, etc) listed as the headers in the first column. One of the demographics is which state they're affiliated with. Each individual has a column with their states 2 letter abbreviation associated...

I have a single document that has individuals personal information (first name, last name, demographics, etc) listed as the headers in the first column. One of the demographics is which state they're affiliated with. Each individual has a column with their states 2 letter abbreviation associated...

-breakdown sheet PIC View image: Shift Breakdown - Schedule sheet PIC View image: Schedule Sheet hope someone can help me, I manage schedules in my job, but with a lot of employees, takes a lot of my time... Currently I have a schedule sheet and a breakdown sheet... Each day I look...

Hello, I need help... I have a list of x number of names in a column (at least 50, but the list could contain 300 or more names including empty cells), and I want the names to be "randomly" sorted with one name at a time being selected and output into a separate cell, without repeating, for...