channel

  1. A

    When will LAMBDA function be available for the Semi-Annual Enterprise Channel?

    Hi all, I would like to know if anyone has any knowledge about the release date of LAMBDA functions for the Semi-Annual Enterprise Channel? It has already been release for the Current and Monthly Enterprise Channels but not mention to my particular channel. Please take into account that I am...
  2. C

    Univers and Channels for pixels

    Hi, I am wanting to put together a spreadsheet that will calculate my pixel led lights into universes. Each Universe has 510 channels, each Universe increments by 1, you can hundreds of universes. Headings will be Channels used (A), start universe # (B), start channel # (C), end universe #...
  3. J

    Name Range Lookup Not Working Corectly

    Hello, I am pretty new to using Excel in this way, but I have built a sheet that we use to enter in some basic info and the sheet returns values in a specific format. I am having issues getting a table and named ranges to work correctly. What I am trying to accomplish is this. I have a table...
  4. M

    SQL Query - CASE WHEN

    Does anyone know much about writing SQL queries, I have a basic knowledge and trying unsuccessfully to do something I have created a JOIN to a table of data but i have duplicate ID's with different corresponding values in another column ID System Channel 12345 1 1 12345 1 2 11111 1 1...
  5. F

    Urgent Help !!

    Dear All Need an urgent help to get the below scenario sorted. I have attached 2 sets of Data. In Sheet2, there is a TV Ad data aired on different channels. Explanation of each column below Channel: Name of the Channel Date: Current Date AD Start: TV AD start Time MidBreak: Tells about the...
  6. F

    Help Required

    Dear All Need an urgent help to get the below scenario sorted. I have attached 2 sets of Data. In Sheet2, there is a TV Ad data aired on different channels. Explanation of each column below Channel: Name of the Channel Date: Current Date AD Start: TV AD start Time MidBreak: Tells about the...
  7. G

    Drop down list selection

    Hello I have a list of 100 items which are linked to a validation cell, to display as a list in a separate tab. Is there a way that u can begin to type in the cell and the possible options display. Eg if I start typing "cha", then only those which begin with cha will display. Such as "channel...
  8. R

    Highlight/identify last column containing text in each row

    Hi all, I'm usually hopeful that things will be possible somehow when I post here, but I'm dubious about this one... I've got a list of companies in one column, then a column for each meeting they attend, some haven't attended for ages, so I'd like to identify that somehow, like changing the...
  9. S

    Conditional formula

    Hi there, I want a column to return the values either Channel or Non-channel based on the following criteria but having trouble with the exact formula: If column A(District) = Intercompany and If column B(country) = US and if column C(Product group) = Fruit or Veg then Show as Channel or else...
  10. T

    If ... Then statement Compile Error

    Im getting a "Compile error: Expected: Then or GoTo" in an If ... Then statement. My worksheet comes from a data logger that can record 20+ channels of data. The number of channels and channel numbers can change depending on the setup. If the channel is not being recorded the column header is...
  11. D

    sumifs based on column header

    Hi I have a workbook with three sheets 1) staging sheet full of floating column headers (changed as required by colleagues) 2) a sheet populated by a macro that aggregates the results from the staging sheet into a weekly breakdown 3) a summary sheet In the summary sheet I have a table that...

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