Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
Articles & Videos
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and anything else related to the spreadsheet user interface, including error messages.
Hello there Experts Exchange users and helpers. Would appreciate any help for the following functions.
Have the left number set as a countdown on days that are passing by.
For example the day t…
I would like to rank values by minimum order on EventID
Please see attached sheet.
I need to search for a string in say column B, if that string exists, i need to update the cell in that same row in column D, with a value. How can i do this? I can't do it with a formula, because m…
the following is example of the data i have
i want to do a logical test to check whether the last 5 chars of cell string is numeric or text.
i do this =IF(ISTEXT(RIGHT(A2,5)+0),
how to extract numbers and text from column A to column B as follow:
Data (column A) result (column B)
88888-AMERICA S 88888-AMER…
Can anybody help me in finding some special symbols, other language characters etc... by using the Excel find option.
Hasl - Nerez Sp…
The attached file has a list of addresses. The addresses often include several commas.
I want to separate the suburb which will be all of the words are after the last comma, and leave the rest of the…
I copies this code from another thread by Bill Prew (https://www.experts-excha
I am doing a filter to find all of the items with ‘Credit’ then I want to delete these items. The below works fine when there are items in there with ‘Credit in column I. However if there are no items…
I want to check the version details within Excel 2007. How?
Can any one tell me why this code is not working. I want it to search my spreadsheet and display the data from select rows if the correct number is entered into the search field. Basically a basic sea…
Is it possible to use an OR condition in excel averageifs? If so, can someone please demonstrate an example for me?
I have a simple 2 column sheet in Excel. The Y axis is fine showing "count" and then showing a number scale vertically. However on the X axis, the horizontal labels show numbers 1 - 11. I want them to…
is there a way to disable recent documents in word 2010 and recent workbooks section in Office for entire domain users with a GPO? I know I can do this on a individual desktops via
I used the following procedure in order to export and split data into csv files based on specific column reported in the procedure:
I would like to use the procedure a…
How can I loop through all files in folder and read all excel files and copy "sheet2" and copy it to Output excel file as new sheet. New sheet name will be the same as file name it copy from.
I am trying to create a macro that saves down a file to a folder with the corresponding month and year.
i.e. S:2016\10-Oct 2016
If the folder doesn't exist I then want the macro to create one. …
There is a ActiveProjects sheet with hundreds of projects.
I've attached Final Result and Source files (samples with small sample data).
I'm building the Excel VBA app that will do these steps:
When I do this I should get AutoFilters on columns 1 and 3. But I get 2 and 4 (see image).
Tried to fudge it with Field:=0 I get an error.
According to here (http://datapigtechnologie
I have an excel document that I want to require a password to open after 30 days.
I don't want to kill or delete the document, just require a password.
Hi Experts using excel 2010
See attached workbook
Need a formula that does the following look the I'd in column A and if we have a Y in column b then find the corresponding Y in range c2:p5 and al…
I'm trying to get a Sparkline like in the attached image.
The Sparklines options don't seem to have horizontal bars. It should be possible then with Conditional Formatting? If so, how?
Hi all. I have excel 2013, where I'm using PowerQuery to get data from a forum DB, and later count the number of words for each user and for each month, with pivot tables.
The problem is that I get…
I have a load of embedded charts in a PPT presentation
My code opens the embedded chart and pastes in some new data, then closes the embedded chart.
I have 100's of these charts. I am no…
by Patrick G. Matthews Introduction VLOOKUP is a tremendously useful function that allows you to "fetch" data from a specified rectangular range (the "lookup table"); this …
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you…
33,132 points this week
22,679 points this week
Subodh Tiwari (Neeraj)
Kanpur University, Uttar Pradesh, India
17,800 points this week
14,500 points this week
8,086 points this week