Search:

Type: Posts; User: tobermory; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Copying and Pasting Data from Several Workbooks

    Hello there,

    I have 7 spreadsheets in folder S:\MHS\Review

    I would like to copy and paste the data from these 7 spreadsheets to a master file (which ideally would be the 8th spreadsheet in the...
  2. Replies
    3
    Views
    385

    COUNTIFS Dynamic Column

    Hello there,

    I want to use the COUNTIFS with a dynamic columns. Assuming the below is the data set in Sheet1.


    <tbody>

    Test 1
    Test 2
    Test 3
  3. Replies
    1
    Views
    135

    Condiitional Formatting Key

    Bit of a long shot this... but...

    I have a worksheet, called 'Key'. In column A there are around 12 cells inputted with text, each cell is coloured differently.

    A1 has texted 'DS', and is...
  4. Re: Formula to Remove Duplicates from List... IF

    Thanks for your reply.

    Yes I'm aware of PivotTables and how to do this, however for purpose of what I'm trying to achieve a formula'ed version would be more beneficial as I would be using the...
  5. Formula to Remove Duplicates from List... IF

    Hello there,

    I know you can remove duplicates with the 'Remove Duplicates' tab, however is there a way to do it formula wise, including an if statement?

    For instance, in the dataset below, I...
  6. Copying and Pasting Between Different Workbooks

    Hi all,

    I have a 'holding' spreadsheet, which basically holds all my necessary macros.

    A lot of these macros, involves copying and pasting between different different workbooks, on a monthly...
  7. Replies
    3
    Views
    243

    Re: Converting Dates

    You gentlemen are so clever, both completely correct and I'm completely wrong!
  8. Replies
    3
    Views
    243

    Converting Dates

    Hello Ladies and Gentlemen,

    I have a column of dates, that I want in UK date format (DD/MM/YYYY)

    Occasionally, the data I receive the dates are muddled up, some are in DD/M/YYYY and some are in...
  9. Replies
    3
    Views
    232

    Probability Formula?

    There are 3 balls in a bag, one red, two blue.

    Therefore, there is a 33.33% (Cell A1) chance of picking the red ball, and a 66.66% (Cell A2) of picking a blue ball.

    Would there be a formula to...
  10. Thread: Math Help!

    by tobermory
    Replies
    3
    Views
    275

    Re: Math Help!

    This may be too much to ask but...

    Would there be any way to do it if the fruits WASN'T grouped and the qtys not in order?

    Thanks sincerely once again.
  11. Thread: Math Help!

    by tobermory
    Replies
    3
    Views
    275

    Re: Math Help!

    Brilliant!! Thanks very much!
  12. Thread: Math Help!

    by tobermory
    Replies
    3
    Views
    275

    Math Help!

    Hi there,

    Please take a look at my sample spreadsheet I've imported to google. I do use Excel 2016, I've just imported for you guys to view.
    ...
  13. Copy and Paste Data From Anotehr Workbook Without Opening

    Hello,

    Is it possible to copy and paste data from another workbook, without opening it? (i.e copying data from the 'source' and pasting it to the 'Master' file).

    I'd like to copy data (Columns...
  14. Replies
    1
    Views
    192

    Opening most recent files

    This is probably impossible, but I'll ask it anyway. Is there a way to open, say, the 10 most recently modified spreadsheets in a particular folder? At my place of work, a new spreadsheet appears...
  15. Replies
    1
    Views
    159

    Re: PivotTable Error Messages

    Any idea? Any suggestions? :(
  16. Replies
    1
    Views
    159

    PivotTable Error Messages

    Hello,

    I have a spreadsheet, data is always being added to the spreadsheet, and therefore I need to update the PivotTable.

    However, I'm frequently getting error messages upon refresh.

    Imgur:...
  17. Replies
    2
    Views
    184

    VBA if statement

    Hello,

    I hope this is an easy one.

    I have a VBA script, and half way through I would like to stop the script if any cell in row 2, in the worksheet titled "Links", contains the "None".
    ...
  18. Replies
    5
    Views
    275

    Re: Open Another Workbook - Don't Calculate

    Basically, I press Esc while it calculates, thus breaking the script, and then check both spreadsheets.

    The .xlsm file stays on Manual.
    The .csv file is on Auto.

    But upon the csv opening, I...
  19. Replies
    5
    Views
    275

    Re: Open Another Workbook - Don't Calculate

    Perhaps I should explain this better.

    I have a spreadsheet, it's a .xlsm file. It's rather large (50MB) and has many formulas. It's usually on Manual Calculate, as when new data is inputted it...
  20. Replies
    5
    Views
    275

    Open Another Workbook - Don't Calculate

    Hello,

    I'm trying to open another workbook, so that the second workbook just opens, but doesn't initially calculate.

    Here's what I've tried, without success, the original workbook goes to...
  21. Replies
    2
    Views
    1,532

    Text to Columns - Text to Rows?

    Hello,

    I am aware of the the text to columns feature, but in a super ideal world, I'd rather split my entry into rows.

    Without exception, the data I'm looking to split is with the ";" sign. For...
  22. Replies
    4
    Views
    124

    Re: Countifs - Multiple Unique Values

    Thank you very very much Aladin Akyurek, very much appreciated sir. Sincere thanks.

    Could anyone help with my additional request in post 3 (as below).

    Thank you.
  23. Replies
    4
    Views
    124

    Re: Countifs - Multiple Unique Values

    Hi barry, thanks for replying.

    Excel please :)

    I do have another request, if anyone could help.

    In column D, could I ask some sort of statement to ask if Box X has MORE than one unique item....
  24. Replies
    4
    Views
    124

    Countifs - Multiple Unique Values

    Hello, I attach a link with a sample of my spreadsheet as I cannot attach any files on here.

    What I'm looking to do in column G is a COUNTIF formula of how many unique fruits (in Column A) are in...
  25. Replies
    2
    Views
    315

    Re: Double Click Active Cell

    At work we have a spreadsheet with a mass of data, all in pivot tables. If you double click on a cell it opens up another sheet that brings up data specific to that cell.

    It has to be the active...
Results 1 to 25 of 34
Page 1 of 2 1 2