i have more than 50 workbooks with same data but i need specified columns in one workbook
example sharing for your Reference
Hi guys, little bit of an involved question here. The above is an example of my table for sales. I currently have two...
I'm hoping one of you excel geniuses might be able to help me out..
I have a spreadsheet with data filled from F2 - F650. In that column there are some duplicates. In Column G I want to use a formula to identify only the duplicates and not the initial entry.
So for example I...
I am trying to compare numerical amounts on different sheets/tabs for common criteria, for example sales of an item on two months to determine the difference.
I have a vlookup for this, but would prefer an index match
The sheets would be as follows
row 1 row 2
I'm trying to use a sumproduct formula to pull in data from a table with 3 criteria, but I need one criteria to reference a table. Here's an example of what I'm trying to do.
I'm trying to pull how many apples Chris sold in each state. Sheet 1
I have a table with different dates in column A
I also have a list with different prices depending on the time of date.
I want to make a...
In one "master sheet" in cell "A1" I have the date 1/1/2020. This cell / date controls many other formulas in my workbook. In cell "B2" of another sheet I have a formula that equals cell "A1" in my master sheet. I need cells "B3" and below to proceed with 1/2/2020, 1/3/2020, etc...
I have the following data in columns E and F.
In G via a loop I am trying to populate - I have given a few examples in the right column as to how it should look. This attempt isn't quite working.
Dim i As Integer
Dim j As Integer
Good Afternoon All;
I am running into an issue I can't resolve with a data export. The data exports with what I suppose would be called a "Header" row, with the corresponding data in the rows beneath. There is no certain number of rows beneath, and due to the size of the file I can't do this...
Hi, I would like to be able to take a quantity and "round" it based on a list of rounding criteria.
I am having trouble trying to find an exact example of what I an trying to do nor am I having any luck myself with the different formulas.
I have created an example using fruit if someone could...
I'm stumped. Been trying this all morning.
I have an excel file with two sheets:
A. Master List + Output -- contains the base list of value that I want to check presence for against in all other columns in the "Daily Orders" sheet.
B. Daily Orders -- contains lists of each day's purchased...
Sorry for the vague description but not sure how best to describe this. Here is the situation below. I want column C to be a formula. Out of all of the occurrences of Oranges in column B, if any of them have a value of 5 or above in column A, then I want it to return a Y in column C for all...
Hello, all. I don't seem to be able to find this specific variant of a value-matching formula.
I'm trying to output the list in column "ValueIsPresentInA-B-C", where it checks all of the other columns for values that must be present in each each of the others and then populates the column.
i have a spreadsheet with multiple columns. One of these columns have a numeric value. I want excel to group the data based on a sum on this column. example: each line has 2 columns, one a name and one a value (which is a point).
line 1 apples 5
line 2 pears 3
line 3 grapes 4
line 4 grapes 2...
Hi all, I am trying to find the best way to fill up a dynamic table with the right values as easily as possible (hopefully one click) once I input the the order number and it's details.
I am stumped not sure whether I'll need to use helper columns / vba.
I wanted to get the answers to the "To...
I have a list of values that is seperated by a return. How do I sort each cell in alphabetical order without moving the row?
I have a data set and Im trying to look up a specific value based on an initial look up in one column and then a secondary look up in another.
So data would look something like this:
A B C
Apples Granny Smyth...
I'm wondering if anyone can help me with working out how to add a hyperlink based on certain conditions.
I have two worksheets - Worksheet "Catalogue" has a dropdown list to select which fruit and another worksheet which has information about the piece of fruit selected. There are multiple...
I want if it contains a predefined value in a cell, to delete that row but not before to add the value that it has to the upper one, example below:
A B C
1 apples 30
2 orange 105
3 test 5
4 carrot 40
5 test 10...
I am having trouble with a formula to determine the latest value on a vlookup. The following is an example: