1. S

    Group By Character Name and list all Scene numbers

    Hello All, Hope you are doing Fine. I have Excel data as shown in the below table. Can anyone help me to get the desired output? SCENE NUMBER CHARACTER NAME E01 SC 01 MICHAEL E01 SC 01 JACK E01 SC 01 ELIZABETH E01 SC 02 JOHN E01 SC 02 MICHAEL E01 SC 03 JACK E01 SC 03...
  2. M

    Return a unique numbers of sales list, values as categorized smallest to largest.

    Hi, Required a formula help for generate a unique numbers of sales list as a sequence to be smallest to largest unique numbers without blanks as based on data contains in column A:G. Sample are enclosed, Thanks for help, ABCDEFGHI1Total Sales Units21015101410Return unique numbes...
  3. A

    show values from one workbook in another workbook

    Hi folks, I was wondering if there's a way to get values (with a filter or find function) to show up in a workbook, by looking the values up from another workbook. the left photo (workbook 1) contains all the values and workbook 2 needs to show the values with offsets to the name and article...
  4. M

    Required a formula to return combined a list, common values in a both list, values not included in each other List.

    Hi, Required a formula help for do a different types of workouts as based on data (Work items list-1 & 2) contains in Column A to C, for there required details as follows. In a Column E, Cell number E4 to be return a Combined work items lists (merged list) of both lists into one list, Sort A...
  5. M

    Find and Lookup, return values based on priority in list-1 sheet

    Hi, Here I have a list-1 in that list need to be extract the required items only in list-2,One is high level and Second one is blank cells where yet to be decide work location priority level. and as per Priority level there should be return further values which are contains in a same row. I...
  6. N

    VBA Copy, Find and Paste Values to Different Sheet

    Hi All, I have a file which is essentially a record of projects (+150) e.g. project title, leader, start date etc., and there is a second sheet containing some formulas to calculate project value. I'd like to be able to copy the calculations from sheet 2, and paste them as values on a specific...
  7. D

    Highlight cells with Conditional Formatting using large range of values

    Hello all, this is my first post. I’m having an issue with Conditional Formatting. I work in a warehouse, and I am having issues in a certain section of the warehouse with items being split across several different stock locations rather than being consolidated into 1 or 2 locations. There is...
  8. T

    Macro to pull all amounts into a message box or userform and ask me which ones to edit etc

    Hi Everyone, I have a list of direct debits, sometimes I need to edit or adjust the amount i'm paying for one or more of them for that month I need a macro that can ask me which ones I want to change and by how much and then add reduce the following months amount by that amount? So here in...
  9. P

    Help Matching Two Columns and Showing Non-Matching Values

    Hello, I am working on a project and it has been a while since I've had to use any VBA, so I'm saving the time and asking. I have data on two separate worksheets. I want to compare column B on Sheet 1 with column N on Sheet 2. Any values that do not match between the two columns I would like to...
  10. G

    Conditional formating where there are 2 values in a cell

    Hello, before i start rebuilding a spreadsheet to split values into two cells, is there anyway to conditionally format a cell, based on one of the values contained in it. for example <colgroup><col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;"> <col...
  11. T

    User Function returning #Value

    Hi All I am currently using the below function to show if a row is hidden or not, when i first use the function it works perfectly but as soon as i unhide/hide a row all the values change to #VALUE . What am i doing wrong? Public Function isvisible(rng As Range) isvisible = Not...
  12. L

    Stack values in Columns / Rows

    Hi Everyone, Thanks for this awesome forum. I've spent a lot of time on here in the past and am normally able to get answers from previous posts but this time I can't so trying to post myself. I want to write a macro that takes the values of a set of columns (the number of columns will vary...
  13. J


    I am attempting to complete SUMIFS and COUNTIFS and am not getting any results. A sample formula I am using is: =COUNTIFS('Tracking Sheet'!$H:$H,"2016",'Tracking Sheet'!$D:$D,"Repaid",'Tracking Sheet'!$D:$D,"Closed") If I break the formula apart and only have two arguments, I get a result. I...
  14. G

    Insert Found Column

    Set fnd = Range("8:8").Find("WBS", , , xlWhole, , , False, , False) If Not fnd Is Nothing Then Intersect(Range("8:5000"), fnd.EntireColumn).Copy Range("B8").PasteSpecial xlPasteValues Intersect(Range("8:5000"), fnd.EntireColumn).ClearContents End If Hello The code above is working...
  15. K


    i have initiated value for some variable inside a module and called a subroutine.Inside that subroutine i have formula which uses those variables.will the subroutine recognize those varibles and their respective values even if i dont pass those values as arguemetns into subroutine?
  16. B

    Match all values in one column and return consolidated results from matched rows

    Hello, I have a spreadsheet with multiple sheets. Sheet1 Column A has alpha numeric values in it like M1, M2, L1, various words, various numbers, etc. along with empty cells between them. There may be duplicates values as well which is normal for the data and I need those duplicates accounted...
  17. R

    Particular Indirect and Match formula

    Hi Guys, I need help in order to change the indirect match formula, I have these data to Match. <tbody> #FCE4D6[/URL] "]Values #FCE4D6[/URL] "]Roma Sub 1 #FCE4D6[/URL] , align: right"]85000 #FCE4D6[/URL] "]Pisa Sub 98 - 287 #FCE4D6[/URL] , align: right"]176700 #FCE4D6[/URL] "]Pisa...
  18. A

    Referencing values from different tables and ranges

    Hi.. I need help to develop an excel formula in referring values from different tables and ranges and add the value to basic size and place the results in respective cells. the demo file is at below link, and also one small explanation of my requirement. Kindly help... Thank you in advance...
  19. D

    Min and Max in sequence

    Good day, I have two columns of data, 1st is time and the second are values, The time column is from 4.00am to 4.00am the next day increasing by 1hour intervals, the values increase to a max and then decline in a series of highs and lows. I want to calculate the change in value meaning the...
  20. Q

    Search for a number in a column of alpha numeric data and display only the non numeric data

    Hi All, So I have a column which has only numbers. For eg. 345678, 674567. I want these individual numbers to be looked from a series of data which have corresponding Alphanumeric Values eg. 345678 - Computers, 674567 - Printers on. How do I place a formula which looks up the...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

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
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 "".
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.
Go back