Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
Claim your profile
Articles by Detlef Lewin
Re: Removing duplicates when using TEXTJOIN
Hi, I am using TEXTJOIN to being into one cell entries from a separate column, where I am ignoring empty cells and separately by &. This works fine. However, I can have duplicate values in an individual cell in the column I am using in my TEXTJOIN and I'd like to be able to supress duplicates.
Re: Need instructions on how to clear a cell in a worksheet
cancel Turn on suggestions
Re: HOW TO: "If cell contains specific text then return specific text"
If I have a list of things, and I want to have the return from another list if it contains certain keywords. In the appendix of file, the column A is the original list, and I want to have it return "good" in B2 if A2 contains "apple", and return "nice" in B3 if A3 contains "help". Just to search if contains words in column E will return the result in column F.
Combinating of sumifs and countifs.
Hi, I Countifs with criterias "BCT", "LT", "232A01" (1). Sumifs of sales for that criterias( 2). The expected result:= (2)/(1) Hope for your help Thank you.
How to count cells based on date and if not empty
cancel Turn on suggestions
How to make a list from an excel spreadsheet with many columns
cancel Turn on suggestions
sorting cells and with attached notes aligned
I know this is a stupid question but, here goes. I have a spread sheet where some cells have data that has been sorted by date. Some have my comments attached concerning incidents that relate to the number listed in the cell. I sorted the list, to be in Date order, date was in column A. Data i entered was in columns M through Q. Notes were attached to each cell.
Re: Pivot table displays only month of full date - can't display year.
Hi. I have created a pivot table from a data set. One of the fields in the data set is a date field (and I've checked, Excel is recognising it as a date in the format mm/dd/yyyy). However, when I add this field to the rows of my pivot table, it only displays the month in text format (ie, "Feb"), and then creates a separate column with the year. I'm trying to get it to display the full date in the pivot table in a single column, not split. Please help?
Excel 2007
I cannot access any data and all of the choices in the Tool Bar are Greyed out
How to get certain data from a pivot table
Hi all, I have a table that I'm using to track weights of fish, the data goes back a couple of years and contains, Name, date of capture, weight etc. What I can't work out is how to create a pivot table that will show me the name and the weight at the last capture. I kind of got it to work by adding date to the values field and setting to max and adding name and weight in rows but this looks really messy in a chart.
Vlookup behaving strangly
cancel Turn on suggestions
Re: Excel Extremely slow when zooming to 10%
@Detlef Lewin @Riny_van_Eekelen Hi Detlef & Riny: Now I think you are seeing my dilemma. On some computers it is fine, on others it is a problem. I don't think it has to do with conditional formatting, as I was able to reproduce the situation with just the data portion of the file and zooming in and out and also copy blocks of it. I currently have a Windows 11- Build 22621, Office 365 Excel build 2211: on a Intel I7-10750H @ 2.6GHz, with 16GB Memory and NVIDA graphics card.
Re: Filter Function Dynamic Arrays
Dear All I have one question for all of you, is there any possible condition in filter function in multiple ranges or with nested formula use of filter function.................... Q.: I want to use multiple range in different sheets in filter function i.e. =filter((sheet1!a1:a40, sheet2!a1:a40), (sheet!a1:a40)*(sheet2!a1:a40),""). But final result is #N/A, How can i solve it. Q2.: Formula should be spill.
Need formula help for countifs and sumifs
cancel Turn on suggestions
Excel Announcements @ Ignite 2019
11-04-2019 06:00 AM 11/26 Editor's Note: Updated links to Help articles and visuals showcasing sensitivity labeling functionality. Microsoft Ignite 2019 has begun and there are lots of announcements coming your way throughout the week.
Annoucing XLOOKUP, successor to the iconic VLOOKUP
08-28-2019 09:00 AM We are excited to announce XLOOKUP, successor to the iconic VLOOKUP function. Before I describe XLOOKUP, I want to take a moment to reflect on VLOOKUP's incredible history and impact on spreadsheeting. VLOOKUP has been with Excel from the beginning; it was included in Excel 1 for Macintosh released in 1985. For 34 years, VLOOKUP has been the first lookup function learned by Excel users and our 3rd most used function (after SUM and AVERAGE).
Show More
loading
Actions
Is this you?
As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.Get in touch with Detlef
Contact Detlef, search articles and posts on X, monitor coverage, and track replies from one place.
Learn more about Muck Rack