ten

Scenario: I am trying to find the best way to search one row across ten non consecutive columns to see if criteria is met. This row is one of a thousand and the columns are ten of ninety-five. My goal is: If B3="V" AND AF3="B" AND Q3-AQ3 <=|2.25| OR AH3="B" AND Q3-AS3 <=|2.25| OR AJ3="B" AND...

I am looking for a macro that will look at a data set (contained in columns A through I with the 'Date' in Column B) and copy/paste the first ten lines associated with each date into a new data set until all dates are cycled through. Suggestions?

So this seems it should be simple but i cant get it. I want to remove all non alpha charectors from a spreadsheet but not the spaces, which is where i am getting issues. So if I had [ "bob's Number*1 ten." ] the results would be [ bobs number1 ten ]. Any ideas? Thanks.

I am trying to optimize the following and not sure how to do so. I have a list of 50 items. Let's say ten of them need to return a value based on the item in the list whereas the other 40 need to simply return a default value. For example, I have a list of vendors and need a column for the...

What I would like to do is to read through column g and compare cell by cell to see if there is an existing worksheet in the workbook with named like it. If so copy that entire row to that worksheet and if not create a new worksheet with that name copy the 1st row of the original worksheet and...

Is it possible to search thru a colum, say "E", and for each matching entry cut the entire row for each entry and paste them to a new tab. So if colum "E" had ten entires with the word "Ball" all ten rows would now be moved to a new tab called "Ball", then the same for "BAT", "Glove" etc for...

I’ve got an excel file containing freight detail and I’d like to construct the following formula: <colgroup><col width="64" span="10" style="width: 48pt;"></colgroup><tbody> IF order # is between 100-199 and receiving location is one of the ten locations then - freight in IF...

I have two columns of data in Column A and B. In column A, each cell could contain one to ten e-mail addresses. In Column B, each cell could contain one to ten e-mail addresses that could be the same or different. So A1 could be as@hotmail.com, as@gmail.com, as@yahoo.com B1 could be...

Hello Excel Experts I'm trying to set up some drop-down menus, with the first one determining what will show in the second one. The first one (and I'll use the actual cells in my sheet so I don't get confused), located in cell E15 will show a range of numbers from 1 to 10 - defaulting to 1. The...

Hi, I have a query regarding DartPart and the format of the value it returns. My example is using date 01/01/2018 If I use DatePart("d", #01/01/2018#) the value is returned is 1. However, what I would like is to have the value, if less than ten, to have a proceeding zero, eg 01. How would I...

Hello all, Is there a way to make a workbook require or remind a user to save at a set interval, say, every ten minutes? Didn't see it in options... Thanks!

For a row, range is B1:CW1. Then I would like to copy the format to the following row/s.