media

  1. M

    Working with average prices

    Hello, I have a stock price control spreadsheet, where I need that every time I add or remove a certain stock, that the system make a new average price and add the amount of buy / sell shares, I will put the spreadsheet for better understanding: I did it the way I can, but maybe, with the use of...
  2. R

    Environ use (blackslash vs. forward slash)

    So I have a question on the use of Environ function in VBA. If I want to open a file from my desktop, it appears I need to use forward slashes instead of backslashes? Is this correct? Is there a forward slash version on Environ? Private Sub PortConvey_Click() Dim sPath As String 'MTS...
  3. W

    How to add comma to my concatenate formula?

    Hello. I am seeking how to add a comma to this formula {=CONCATENATE("and ",SUM(S2:S500)," in total Media Value")} so that a comma separates the thousands place in this result {and 1862943 in total Media Value} Thank you in advance for your help on this.
  4. G

    How to obtain song duration or title of song being played by windows media player

    I want to obtain the duration of a song being played by windows media player or the song title. I have no idea how to do this, please can you help? Not being that good I need code examples to follow or try to adapt. thank you in advance glassescase
  5. N

    Array Formula for unique counts

    I have column A with values such as col A col B ----------- ------------- Software SO1 Media ME1 Hardware HA1 Hardware HA2 Software SO2 Media ME2 Hardware HA3 Software SO3 I am looking to add a...
  6. T

    Pulling info from one column to a different sheet

    Hi all, Quick question....So I have two sheets. I need a formula to pull Column A info from Sheet 1, to COlumn B of Sheet 2. Is it Vlookup? Or something else? Having trouble getting it to work. Thank you! Sheet 1 Column A Column B Linkedin Social Media Indeed...
  7. D

    Sumifs with a range of columns to sum

    <tbody> A B C D E F G H I 1 SumClient Yr Period Invoice Date Item Code Cost Disc Adj BALANCE 2 A569 2018 1 12/01/2018 MEDIA 100.00 212.14 3 A569 2018 1 12/01/2018 MEDIA 56.25 (3.25) 4 A569 2018 1 18/01/2018 MEDIA 56.25 2.89 5...
  8. nikio8

    Transposing/Summarising data based on one column

    Hi all, Basically I have two types of stored data, that needs to be reconciled against each other based on media type. The issue is that one has media is all in one column, not as headings. I would like it to be as it is in the columns F:K, which is a pivot table, as well as what server data...
  9. H

    Access Query Returning 95,000 results

    Hi everyone, I am having an issue with my Access Database returning duplicates. Context: At my workplace we prepare microbiological 'Media' (Agars etc.), which is held in tblPrep_Records. There is a table containing information about the media, including the price per litre. I have...
  10. D

    Sumifs where columns are transposed

    How can I do a SUMIFS (or similar) where columns/rows are transposed. In my data sheet data is organised like: <tbody> 3100 3587 2568 3800 Talent 200 320 124 256 Sourcing 90 77 85 784 Media 45 69 30 941 Talent 426 25 24 4256 Sourcing 497 74 85 287 Media 569 36 26 365 </tbody>...
  11. Stridhan

    Dim player as object ( windows media player )

    Hi Is there a way to declare the windows media player as an object or variant only by the default references? Its not in a form. If yes, how? :eeek: Im on excel 2010.
  12. A

    Problem Logging in Mrxl .com

    when I open log in page of Mrxl.com the following Text Bar hides the Log in Dialogue Box. How may be it fixed. Thanks in Advance This website uses cookiesWe use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to...
  13. A

    Problem Logging in Mrxl .com

    when I open log in page of Mrxl.com the following Text Bar hides the Log in Dialogue Box. How may be it fixed. Thanks in Advance This website uses cookiesWe use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to...
  14. FATS

    Excel 2003 XP Macro for a Windows Media Player Detector

    Hi folks, Does anyone know how to detect what state Windows Media Player is in? - Such as whether it is currently playing, stopped, or simply paused. - not the userform version, but the full application. Thanks.

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 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.
Go back
Back
Top