titles

I am using Excel 2016 and want to add rows to repeat. I've tried the three approaches listed below. No matter which way I use, the Print Area and Print Titles are all greyed out and cannot be accessed, although I can change everything under Print Titles (Gridlines, Black & White, etc). Any...

Something like [=MEDIAN(ABS(C3:C20-MEDIAN(C3:C20)))] works but I can not find a way to define this statistic with a range of C:C so as to be able to see the change as soon as I add values? I thought that [{=MEDIAN(ABS(IF(AND((C:C<>0),(ISNUMBER(C:C))),C:C)-MEDIAN(C:C)))}] Would exclude empty...

(Windows 7 ENT, Excel 2016) I have data in a helper table at AB57:AE60. (4x4) for charting in a workbook. The columns are: "Which Data", 2015, 2016, 2017 The rows are: Data 01, Data 02, Data 03 Referencing a drop-down list located at AB2, If AB58:AB60=AB2, express the appropriate row of...

I have 2 tables, the first has Job Titles, I want to search the text of those job titles to see if they match any standard terms stored in my second table. My second table, which contains the standard terms, has multiple fields I'd like to search through to return the records that match. For...

Hi I have written some code which opens a folder and display a list of CSV files. (This would be done after a user has downloaded a report from a website). However, I need to write code that verifies the contents of the file i.e it i) checks how many columns there are (there are 8 in...

Hello guys, It is the first time I post on this forum, so please don't blame me :) I have the following issue. There are 2 columns. One with discipline codes and another one with the Job title of the employees. I have to calculate the percentage of Job titles...

Dear Team ! I have an excel sheet containing 25K records. Titles includes First Name, Last Name, Title, Location, Company & Email. I wanna use my sheet as a database. For example I need all Junior Accountants in titles from Los Angeles, the should be displayed accordingly. How to apply...

I have a sheet with several pivot tables, graphs, tables, headers, etc... stacked vertically. The first couple of pages of content fit on onto their own single page, however, the last Pivot Table spans 4-5 pages and to throw a wrench into things, I am using the pivot table to add long formulas...

Hi, Hope somebody can help me with a formula :) I would like to search through text to find certain ID numbers. For example: CSAZ11871Z YA6200046Z YA7300232Z YW0600782S DAIC03798Y The strings I look for always contain 10 characters and always have both numbers and letters in them. FYI...

Sometimes I have to add charts to a page of old chart made with a previous version of excel, but I can never get the graphs to look the same. The chart titles in the older version are darker, while the new version chart titles look lighter and more washed out. Even if I match the font, font...

Hello everyone, I just joined the forum, and this is my first post. I am totally naïve to running macros and need your help to automate the consolidation of multiple worksheets. I have around ten worksheets - columns A to M are fixed in all the spreadsheet and rows keep changing as and when...

I have a macro I use daily and want to add a few things to it. I had a ton of help with what I have now (code below) and tried to add the stuff myself, but it turned into a disaster. So back to the drawing board. Any help is greatly appreciated! What I've been trying to do is add titles...

Hello, I was wondering if it was possible to insert 2 blank rows after a data change in a specific column (i.e. group the data), then to hide that column, and use the data entry as a title (in bold) for that group of data. For example; Col A Col B 1234 Apple 5678 Apple 9876...