identified

As follows: If cells J56 and N56 are not blank then return the value posted in cell E72 only if cell E11 on the worksheet identified as "Candidate Selection" equals the alpha character "C" and cell G11 is not blank, otherwise return a blank cell Tanks in advance for the assistance

Hey All, I thought this was an easy tweak, but apparently not so, atleast for me. Must have something to do with how excel is dealing with thearray formula, so hopefully someone else has a better understanding. This is my current formula...

Hello, I'd like assistance with figuring out how to determine the name of a carrier based on how the first few characters of a tracking ID begin with. The problem is some characters can instantly identify a carrier by the first character and other can be identified by 2 or 3 characters...

Hi there, I would like to help out some of our sorting guys at our company. We receive parts with barcodes and sometimes without. They are car parts from junkyards. I want to make the sorting process better since things get incorrectly identified and I end up re sorting them. I bought a...

I have a column of values i want to add if the value in another column is less than or equal to a number identified in cell b1 which can change. I can sort of do it using the following: =SUMIFS(C4:C15,A4:A15,"<=5") but I want where it says "5" in "<=5" to point to B1's value when i click on...

Hi, I am looking for a simple macro for 1. Read the date in Cell K2 (Sheet 2) and find the same date in Row 1 in Sheet 1. 2. Once the date is identified, copy data from Cell C2:C230 and paste it under the identified cell. For Example : If the Date is identified in cell H1 of Sheet 1, the data...

Sheet 1 - Summary page with County names in 10 columns Sheet 2 - All sales for out company - 3 columns - ZipCode, Total Items sold to that zip code, Dollar Value (Columns A-C) Sheet 3 - List of Each NH County and Zip Codes - 10 columns with each row containing the zip ode for that column...