author

Hello, starting from this sheet with column A (title, responsibility, publisher) I would need a formula that extracts only the publisher in column C. I used this formula: = LEFT (MID (A2, FIND ("-", A2) +1, LEN (A2)), FIND (",", MID (A2, FIND ("-", A2) +1, LEN (A2))) ) -1) but column C gives...

Hello everybody, I am currently looking at excel/PowerPoint, where you have the following when you open a document: In the cases above, I have simply opened a blank document. However, what annoys me is that if I use a template from any prior documents, it will say the names of the authors...

At this link I did not get an answer to my question. Maybe I'll have more luck in this forum. It is common knowledge that with SaveAs in the (MS Office) window you have the option to enter the author before saving the Workbook. Just type in one letter and Excel will list all the authors that...

Hi I have mastered getting the last author and date from the fileA i have open my master file but i would also like to pull the author and date from another file i have open at the same time, my data input file to see when the last time the data input file was updated. at the moment i am using...

I've been trying to figure this out for at least ten hours total now, and I have to admit I cannot do it myself. I'm just too new at VBA and too bad at programming. Ultimate End Goal: to create a table of Authors based on data entered in a primary table, upon entry or update, without duplicates...

Am looking for, but cannot find a explanation for the role of the number one in this function: =IF(A2>1,A2+C2,"") Column A contains dates, 01/01/19 Column C contains numbers, 13,16,20,21 The end result if a calculated date. But, I was not told what purpose the ">1" in the function serves and...

I have a spreadsheet full of data in multiple columns. I want to filter on two of the columns on a few criteria and then send the results to other worksheets. So for example, each time I have country a, county b and country c in column A (book titles) as well as author a and Author b In column...

Hello, I am trying to create an excel function that will identify two specific words embedded in messages of varying lengths (that I scraped from a message board online) and delete all the text in between those two words. Specifically, the message board that I scraped the data from allowed...

Hi I have two problems. I need my spreadsheet to automatically make a backup copy of itself each day, with the file name to include the date. Is that even possible? Also, when any cell in a row is changed, I would like a cell at the end of that row to show the now() date, time and the user...

Both of these codes go down 8 rows past the last row. My headers are in Row 4 and the data starts in 5 down Sub Find_FloorStock() 'Author: G Heyman 190221 'Update "Type" Find Floor Stock and change from B to F" With Range("G5", Range("G" & Rows.Count).End(xlUp)) .Value =...

Hi I am reading the article below which list most popular functions in vba. https://www.excelfunctions.net/vba-functions.html I am not sure based on what the author listed all these functions?? Where are these functions located? Part of which class? I tried to user Object browser but could...

I have a spreadsheet with authors of articles in one column. Many of the authors have several entries, and there are 100 rows total. For example [ Author t, Author u, Author v] [ Author x, Author Y, Author z] [ Author A, Author b, author x] I have to find out how many times the authors are...

Hello, I have a long list of books sorted by author. I need to highlight the authors with 10 or more books. I have a column that shows the count for each author using this formula:=IF(C3=C2,H2+1,1) where column c holds the authors names and column H counts each book for the author and starts...

Hi guys, This vlookup problem has me scratching my head. For the following table I use the vlookup formula below to lookup up book title, author and price in different cells at the same time. It includes a COLUMNS function to paste it across cells to return book title, author and price. Whats...

I'm starting to use the advanced filters for sorting through my lists of academic journal articles. I like the ability to execute OR searches across different columns. My current issue is trying to apply the advanced filter to find cells that contain, in any order, several strings. For...

Hi I am reading the article below and the author is using Combo chat. I am using excel 2010 and I do not see combo chart? any idea why please? Thank you. http://www.guru99.com/creating-advanced-charts-in-excel.html

Hi In this excel sheet, there is a column called "Satisfaction on management" (in Data2 sheet) and it has values from 1-5. So the author created a pivot table and has a Row label in pivot table like this <tbody> Satisfaction on mangment very satisfied unsatisfied mixed very unsatified...

Hi All, New to the forum but have had loads of help from reading all the articles in the past. I have a tricky task which I am trying to achieve with excel and not sure if it is possible. I have a table that is laid out like below (with a couple rows completed). I want to be able to...

Hi I am trying to follow the instructions on how to combine 2 charts in excel (please see the link below). I am using excel 2010. Can I do what the author did in that article using excel 2010. Thanks a lot. https://www.guru99.com/creating-advanced-charts-in-excel.html

Okay, here is my situation and here is what I am trying to do. I hope there is a relatively simple solution. I have a spreadsheet that lists all of the audiobooks I own and it is broken up by author. Each author has a worksheet. Each worksheet has the list of books and a total of the books I...