how to find distinct row in excel
I have A:1 to A:158 cells and they have values like
aa
bb
bb
cc
cd
aa
sp
I want to get only distinct values. How can I do that?
Hi
The user must select from a data vbalidation list in Cell F4.
What they choose then determines the next data validation list.
The IF statement I am using is:
=IF(F4="Uni Hospital ...
I can't believe this is so hard. I think I've seen 100 answers on EE to this exact question and I still can't figure it out.
I have a SQL Server database with a table called Branches. I w...
I need to come up with a weekly workplan template. Essentially, it should look like a weekly calendar (Mon - Fri) with hours from 8 to 5 for each day.
I'd like to include some automated f...
I need to calculate the standard deviation for 11 data points (see below). I'm familiar with Excel's formula:
=StDev(cellrange).
Based on data, I'm not sure which column (B or C) I sho...
Hello,
I am looking for the word "HELLO" in a colum of a spreadsheet (there should only be one instance of the word), I just need to know which row it appears in, how can I do this in VBA ?...
I'm trying to open .xla file and i m getting this error:
Opening the VBA project in this file requires a component that is not currently installed. This file will be opened without the VBA pr...
I found on this excellent site a short macro to export an excel chart to an image file.
Could someone provide additional VBA code to have all charts of the workbook exported instead of only...
I have some data on an Excel Spreadsheet that is cut and pasted from another app:
1. a cell with the year as a string, for example "2004"
2. a cell with a Month as string, for example "Jun...
I am looking for a formula for excel to produce an "S" curve. It will be used for Project Control purposes in developing proposals. I wish to give it a number of variables:
1) Start
2) End...
When I open an Excel spreadsheet I get the message "C:\Documents.xlsx could not be found" I have to click Ok. I then get "and.xls" could not be found and then ""settings.xls" could not be foun...
Every time one of my users tries to open Excel, Excel appears to try installing something then gives an error saying D:\pa561401.cab is missing. It only allows you to retry or cancel. I am n...
Hi,
I have some data that is exported to Excel, and I am using the formulas of RSQ, Slope, INTCPT to get the answers I need, but I also want to get the Standard Error's associated with the ...
Hi All,
I am copying Excel Sheets from one workbook to another workbook. The process is taking long time so i want to add a progress bar to cover up the time.How to increment the progress bar...
I asked the same question earlier, but perhaps this question belongs in this section.
I am writing a small piece of VB code for Excel to prompt the user to open the file he needs to work w...
I am looking to Extract the Month from the Date/Time field in a worksheet. There will always be a date/time entryin in cell C2. The information in the cell is in this month/date/year and tim...
Hello,
I have cells that have data like this:
37:13:00
but I if I highlight the cell in the top bar in excel it shows the cell's contents as this:
1/1/1900 1:13:00 PM
if I copy and past...
Looking for some good links to understand vba scripting dictionary and/or some examples
Hi,
I've coded a macro that will loop a set of data and pick out the row range that needs to be copied over.
When I try typing this:
Rows(startCutRow & ":" & endCutRow).Select
I ge...
I have a macro that does the vlookup from one sheet to the other, the code's below..
Application.CutCopyMode = False
ActiveCell.Formula = _
"= VLOOKUP(RC1,'[" & wb2.Name &...
This should be an easy question, but I am new to Excel coding...
I have a range of cells (all in one column), which I want to append some extra text to the end of each cell. How should I d...
There is one user who accesses excel spreadsheets via a network share who often gets error message: "filename.xls is locked for editing by the username(its the user themselves) click to notify...
I have two excel spreadsheets. One is a list of customers with their names and addresses and id numbers (unique for each customer). The other is a list of items the customer bought with ea...
In the code segment below, after the "End With", the wksSource.UsedRange.Clear line does go to the proper workbook at Sheet1 and does clear everything on the sheet. I also need, after it clear...
In Access 2007 I have set up the Date Picker which is very handy and easy to use to show the date, can I set up the same within excel to pick the dates from a calender
