I have two spreadsheets both with multiple columns. In both of the spreadsheets there is a column that contains a unique URL. I need to run a formula that will only leave ALL the data for the rows that contain the same URL in the URL column of both spreadsheets. Hope that makes sense. For more...
Hello everyone,
I am struggling to come up with a formula to find every unique value between two different columns. I would want it to identify a unique number only if it is unique between the two columns i.e if "5417" is in once on column A and once on Column B I am fine with that. That...
Need to filter a list of ID's (with multiple entries per ID) which includes end dates for events and a "day count." Ultimately, I need to get the number of ID's (not which IDs, just a count of them) that have exceeded a "day count" (say 220 in a year or 400 in a two year window). Each row is an...
Hello Experts,
I am having trouble in calculating a the 'final value' column in the below table. Imagine you have a text column 'sample_card' which has multiple transactions over a month. Now, a particular card is eligible for one txn per day only. Maximum discount VALUE PER TXN is set at 75...
I want to write a code which will change the corresponding value to minimum of the duplicates set.
Sample Data
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
Name
Number
Ana
1
Rachel
4
Jack
7
Rachel
5
Ana
2
Jack
8...
I have thousands of rows like that -
These are the keywords
<tbody>
A1 NEW NIVIA TOP GRIP BASKETBALL SIZE 7 OFFICIAL STREET A++ QUALITY BASKETBALL
<tbody>
A2 New IXO Collated Screw Gun (Cordless) home use screw gun cordless for everyone
<tbody>
A3 Set of 3 stainless steel soup pasta salad bowl...
Hello I am trying to build a "formula" to show duplicated text between two rows:
The list is sorted alphabetically.
The column "A" is the only column that matters.
Some of the cells have a space in excess so the formula is false, any idea how make the formula dismiss the difference in spaces...
Good day, all
In column AI I am doing a vlookup to another sheet. The info that is returned from the vlookup I want to appear in column N but I don't want any formulas in column N (because people may want to past the info in columns B-T down to other rows on the spreadsheet). Is there a way...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.