challenging

Hello! I need help figuring out how to get a formula I had working on Google Sheets to now work in Excel and was counting on this community's expertise, please! I basically have a table with ticket items where one of the columns for each ticket is called Linked Issues. If an item from my table...

Hello all! I have a challenging obstacle that I need to overcome. I provided a link to my workbook with a few notes that explain what I need to accomplish. I have a single row with criteria in a column above it and different criteria below it along with a column of dates. I need to get all the...

Please see file that I uploaded in OneDrive I have explained the help I need in the file. I would greatly appreciate any help i get. I tried a lot. but it seems quite challenging. Thank you!

Hi! I am creating a template which consists the following: Start Date & Time - contains a start date and time End Date & Time - contains a end date and time nwday1 - Named range (contains non-working 1 day OR first weekly off, it accepts a number from 1 to 7) nwday2 - Named range (contains...

Hi. This is my 1st post in a forum...so bear with me please. I need help! I need to pull data to a new workbook from a single cell in a range of sheets out of an existing workbook and divide it by another cell in that same range of sheets from that workbook. I have looked and the closest...

I will have multiple Excel files that have very similar data in the first column (Company Names), how do I get Excel to find out what the information is in the first column and then post it's website in the 2nd column from a pre-populated list? I have hundreds of Company Names per Excel sheet...

Hi all- I am in the middle of a HUGE dataset and having some trouble calculating the correct units of measure value so I can accurately calculate "net cost". An example is below: Unit Amount: 50 EA/BX 4 BX/CA Unit of Measure: BX Cost per Unit: $9.40 I have a code that I have used to parse...