Index to 'how to'… providing a range of Excel and excel vba code solutions

1	How to copy cell data to another sheet and save it automatically
2	How to Lookup between a starting word and a finishing word
3	How to extract text from a string before a last specified character
4	How to calculate overtime on Timesheet after 10 hours per day AND/OR 44 hours per week
5	How to use cell content as input to a structured reference as part of a lookup function
6	How to add a second condition to conditional formatting
7	How to count blanks if 1 of 2 conditions are met
8	How to use bottom up lookup
9	How to use Formula: =IF ERROR
10	How to extract text string
11	How to count weekdays in a month excluding holidays
12	How to use Excel MID() but counting from Right
13	How to use Standard Deviation Formula in Excel
14	How to use a Macro to copy rows from multiple worksheets based on a cell value greater than zero
15	How to use VBAs Find Function
16	How to get a specific date when you enter any other dates for the week
17	How to read only open an excel workbook (multiple users simultaneously)
18	How to use SUMIFS and include 'All' to Drop-down IndexMatch
19	How to use IndexMatch formula that ignores duplicates
20	How to Compute a Date Difference in an IF statement
21	How to convert time from xx minutes to xx seconds into HH:MM:SS
22	How do I hide data in column until data is entered in columns to the left
23	How to use the DATEDIFF Function (VBA)
24	How to COUNTIF using input cell as range depth
25	How to use COUNT
26	How to use VLOOKUP (example)
27	How to drag a formula to the right and skip x columns
28	How to create an Excel Pivot Table calculated field
29	How to combine more that one IF AND formula
30	How to alternate row colours based on text name
31	How to create a formula for multi criteria lookup with dates
32	How to calculate remaining time to a deadline
33	Insert time/date with click on cell but never update
34	How to calculate amount by looking up matching currency and rate of exchange
35	How to extract characters
36	How to do conditional formatting based on another cell having data
37	How to use conditional format to highlight the blank cells
38	How to remove the last X number of characters depending on the ending of the value
39	How to sum cell numerical values based on text suffix
40	How to create a time series frequency conversion
41	How to sort values in positive and negative numbers with formula
42	How to extract multiple emails separated with semicolon and brackets
43	How to check if two columns match or not
44	How to do a formula to compute IF A1 (number) is <1000 B1 = Bad
45	How to use SUMPRODUCT and COUNT question for unique associations

See also a range of new resources and reference sheets:

Index to new resources and reference sheets.

Go back to : Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals

Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.

Gallery

stars (0 Reviews)

Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation.
OzGrid is in no way associated with Microsoft.

Website designed by Astrava Solutions Ltd.