Search results

Hi I have a dataset of 170 Columns and about 7000 Rows. In the Transform, I need to drag many columns appearing at different locations in the dataset, to the front. I can Select any column and drag it to the front. However, it become very time-consuming when dragging individual column each time...

Hi I have attached 2 files. The sample data is same in both files, however some columns are hidden in data test 2 file. Requirement is to Create hyper-links. e.g. in the ID Slicer of data test 2 file, I click on 56. This will result in row 73 only visible which pertains to ID 56. Then I click...

Hi I have a workbook with lot of slicers. If I saved this as a Web page, the slicer functionality ceases when the file opens in the Web Browser. Quick question: Is this doable (i.e. save spreadsheets with slicers in web format which then allows user to use slicers in the web browser in the same...

Hi In the dummy sample file attached, there are 2 worksheets named week wise i.e. Week of 29 July, Week of 5 August. In the actual document, there will be about 10 tabs belonging to each week. Each individual week will have data date-wise i.e. Mon 29 July, Tue 30 July, till Fri 2 Aug...

Hi Please see attached. As a sample, I have my source data in Column A and B. Data I want to be recorded in is under Mondays to Fridays. (Columns E to I) My requirement: As I type Code "1" in Cell E6, it should automatically record as English. As I type Code "6" in Cell E7, it should...

Hi My data table has 2 date columns in this format i.e. 23/12/2015. I have created a pivot table. In the Pivot Table Fields, I have dragged all the date columns to 'Rows'. However, in the pivot table, 1 column (Date Due) show dates though not in correct format i.e. 23/12/2015 but the in other...

Hi In my worksheet (attached for quick reference), I have disabled Formula Bar and Headings (from View). This file is password protected. Password 8761. I have ‘auto-hide’ ribbon too. However, by doing this, the ‘undo’ and ‘redo’ buttons that sits on the top in the “Quick Access Toolbar”...

Hi, (1) In the attached file, there are 3 sheets. Master, Slicers, Table. All three have hyperlinks to navigate to Master, and vice-versa. Slicers Tab has 2 slicers too. I save this file in the Web format (published entire-workbook). When I open this in the Web browser, the links and the slicers...

Hi I want to create 3 separate Groups i.e. for Columns A to D, Columns E to H, Columns I to L Following steps wont create 3 Groups rather extends Grouping of Columns A to L Highlight Columns A to D and Create Group Then, I highlight Columns E to H and create Group; rather than creating...

I am somewhat familiar with creating macros, and they work perfectly well within the Excel Application. This is what I want to do: Create some data and saved, file closed. Record a Macro in Excel and take these steps: 1) Start recording (from the Developer tool) 2) Open the folder where file...

Hi I have a rather weird question. NETWORKDAYS formula can work for calculating difference of working days provided in e.g. Cell A1 is the start date and in Cell A2 is the end date. What if I write the following in Cell A1 (pertaining to Year 2014): "Monday 6 to Friday 10 January", or...

Requirement: Want to extract, date-wise, all working location (corresponding values) e.g. of Sam, who appears at 2 different rows, onto a separate sheet or may be same sheet but in blank columns e.g. K onwards. Tried to use Vlook but it stopped at Sam at row 3 and did not look for Sam at Row 8...

Hi there, I have rather complex problem (well complex for me though). I have say 3 students Chris, Sam and Matt. Each attending different set of classes each day over one week period. e.g. on Monday Maths/English, Maths/Accounts, Physics/Accounts, Lab/Chemistry Tuesday Lab/Chem...