Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Spreadsheets

5K

Solutions

25

Articles & Videos

4K

Contributors

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

I have about ten spreadsheets in one folder that i need merged into one. Does anyone have a powershell that will combine all excel spreadsheets in a directory into one spreadsheet. these spreadshee…

221 views

hi, this code moves row data from one tab to another and at the same time logs the date and puts the date in the last column. i then end up with Col A with a date and Col H with a date. I'd like to au…

1028 views

Hi all, can anyone give me some code that will add the current date into the next cell when the user selects 'yes'

the code below moves the row of data to a new sheet when the user selects 'yes' wh…

1143 views

Hi all - How do I use Excel to give me the number of rows containing a certain item, for all rows?

See 2 tiny examples attached ... that should explain everything! I want excel to tell me how many C…

446 views

Hi,

Below are the steps I use to change the contents of a cell in one worksheet.

I open my first excel worksheet in my folder. The path is C:\Users\Entities

I go to Review tab and select Protect …

2761 views

- Spreadsheets
- MS Excel
- MS Office
- Programming
- VB Script
- MS Applications, VBA

Hello,

I'd like to make a spreadsheet that can track my earnings in Excel (hourly, overtime and gratuities). I was hoping there's a way to have the spreadsheet ask for input when opening and the…

342 views

Hi

I need to calculate the Z-SCORE Values that would represent the Values of

+4

+3

+2

+1

0

-1

-2

-3

-4

based on the data that I have in Column J. The formulas needs to be kept inside …

452 views

Hi

I need to calculate the T-SCORE Values that would represent the Values of

100 T-SCORE Value

90 T-SCORE Value

80 T-SCORE Value

70 T-SCORE Value

60 T-SCORE Value

50 T-SCORE Value

40 T-SCO…

369 views

Hi

I need to calculate the Standard Deviation Values that would represent the SD Values of

+4

+3

+2

+1

0

-1

-2

-3

-4

based on the data that I have in Column J. The formulas needs to b…

554 views

Hi Experts

I am looking for creating some sort of a Button or some other shortcut type of thing in excel, such that I can place it anywhere within any excel worksheets. And when I click on it, that…

555 views

Hello,

Can someone provide a formula that will pull all the text in a cell that appears before the first appearance of {? For example, if the cell contains the following: Hello World {123} the for…

226 views

Hello,

Using the following formula to split cells based on a certain character: =TRIM(LEFT(SUBSTITUTE(MID(

I am seeking assistance in tweaking t…

137 views

I have been copying random 10% of entire row of data into the new sheet. For example, i have 1000 row of the data, i have to select and copy 10% row of data (which is 100) randomly into the new sheet.…

753 views

Hi

I need to calculate the Percentile Values that would represent the Values of

100 Percentile Value

90 Percentile Value

80 Percentile Value

70 Percentile Value

60 Percentile Value

50 Perce…

241 views

We have a list of files in an excel and want to separate their file extension. We are using a combination of commands like search(), len(), left(), right(). However some files has various periods in…

940 views

The script run I have will get a timestamp of when a row is edited and puts the user in the comments box at the end of the row of cells. cannot get the script to run and get the email of the current …

266 views

hi,

With google sheet I can query any data sheet with one formula, eg:

=query(importRange(SourceD

The output…

938 views

Attached is a sample spreadsheet where I have an IF/OR formula that's not working.

I simply want to return a value based on today's month, which varies in different months.

No arrays, please .…

855 views

I need a formula that looks at all rows in a column, and if the data is "yes" - case insensitive - gives me a count of all "yes" rows.

552 views

Dear Experts,

Yesterday on EE I got two solutions to select the countries which have the highest selling numbers in a row on below printscreen:

Concretely the applied formulas are =OFFSET($A$1…

238 views

Dear Experts,

Can you please have a short look on the attached file, basically on 'Sheet1' there is a small table with Products, which contains selling numbers per Countries (from column A to E):

…

539 views

Hi

I have an 2010 excel file with 200 user details and their date of birth is populated in dd/mm/yyyy ( 29/06/2001)on one of the colums.

I want to convert this format into ddmmyy (290601) . T…

861 views

I have a specific row, "total respondents", that repeats over and over throughout this sheet. I need to be able to search each individual cell in each row and delete all cell values that are 5 or less…

1048 views

I have been running CALC via OpenOffice and LibreOffice for a few years. I do hit problems sometimes with one or other of them but usually they work all right.

I have tried to standardise on OpenOffi…

372 views

201506-LO-Top-001