Hi,
I have an excel sheet that has over 34,000 rows. It has the employees name, payroll date, and time card hours.
Example:
Payroll Name File Number Payroll Pay Date Timecard Hours
John Smith 0012345 07/26/2018 8.00
John Smith 0012345 07/27/2018 8.00
John Smith...
Hi,
I have an excel sheet that has over 34,000 rows. It has the employees name, payroll date, and time card hours.
Example:
<tbody>
Company Code
Payroll Name
File Number
Payroll Pay Date
Timecard Hours
PayCode
AAA
John Smith
0012345
07/26/2018
8.00
Reg
AAA
John Smith
0012345
07/27/2018...
Hey all,
FormR kindly helped with combining two formulas together:
=IF(AND(INDEX(T:T,MATCH(E5,AF:$AF,0))=G5,INDEX(BJ:BJ,MATCH(E5,AF:$AF,0))=H5),"Yes","No")
This formula is replicated in Rows until 1500 i.e...
Hi
I'm using excel 2016
i have a spreadsheet with 56,000 rows and in column I have i have a set of data that is duplicated
i would like to delete the duplicates... however i need to retain the very last row of the duplicate as an example i have highlighted in red below ( the data is just a...
Hi ,I want to SUM after applying filters on multiple columns
Table 1
<tbody>
ID
Salary
Level1
Level2
ID123
6
John
Tom
ID123
6
John
Tom
ID123
7
John
Richard
ID123
7
John
Richard
ID123
8
John
Swetha
ID123
8
John
Swetha
ID123
10
John
Randy
ID123
10
John
Randy
ID123
10
Ram
Rocky...
Hi, I am importing data from a text file into excel.
Unfortunately the text file has stacked columns, so what would be the best way to convert the data from this:
<colgroup><col span="2"></colgroup><tbody>
Name
Address
Number
Zip
John
1234 St.
1111111
44444
Mary
5678 St.
2222222...
Hi
I need a code that will copy and paste data from column D to column B if column B is empty, the code will ignore any empty cells in column D and move to the next cell with data to copy over.
From this
<tbody>
A
B
C
D
JANE
JANE
DOE
JOHN
DOE
JOHN
DOE
JANE
JANE
SMITH
JOHN
SMITH
JOHN...
Good morning all.
I am not all that savvy with excel and am attempting to create a form that will auto fill from another spreadsheet when given a few criteria.
On the column header is dates from the first of a month to the end. On the Y axis are names. In the data range are letters denoting...
Hello, newbie here.
I wonder if it's possible to create a macro which creates hyperlinks for all existing values in a column such that:
1. When user clicks a cell link, a Google search result page opens, showing results based on existing cell string value
2. Tooltip of each hyperlink shows...
Good day all,
I'm trying to pull the weekly attendance of personnel, at the moment i do this manually (not clever enough to do the other bit:confused:), please see my screenshot of an example, I have on another sheet all the week numbers and dates they start/finish on.
So I get the information...
Hi
I have an excel query and i can not figure it out:
I have a list of names in column A and Dates along in Row 1. And under the dates by the names are zeros or BH (Bank Holiday), W (worked), H (Hol) & HF (Half Day Hol)
I am trying to get results by looking at the name i want to know when...
Hi
I have a table like below. I highlighted and then Insert-->Tale.
I click on a cell outside the table and wrote
=sum([revenu])
But I got an error message? Why is that? when I can use Structural table columns? (for example [name], [store], [item]
Thank you very much
<colgroup><col...
I have raw text data in cell A1
I also have list of words that I want to be bolded to that cell. (These words are listed in column B)
I want it to be like this:
Bold every "Jack" and "John" in cell A1:
Jack and John are brothers. Jack is older than John.
Jack likes football but John hates...
Hello there,
Please assist
Please I need a formula that reports how much cookies James sold between
<tbody>
03/01/2019 and 09/01/2019. See table below
<colgroup><col><col><col></colgroup><tbody>
<colgroup><col><col><col></colgroup><tbody>
A
B
Salesman
Cookies...
Hi
I want to dynamically expand my data as follows without using VBA.
I have text data in a single column. There is no empty cells in between the data but the number of rows having data can vary.
<tbody>
Names
John
Sam
Jessica
</tbody>
I want my result as follows.
<tbody>...
Hi
I have a spreadsheet im trying to complete which if done manually will take forever but i cant work out how to automate.
In one sheet i have information as per the below
Date Employee Name Holiday taken
02/06/2018 Joe bloggs
03/06/2018 Joe bloggs
06/06/2018...
I am trying to recreate a multi-page invoice. I have it working as a single page but I think I need to abandon what I have already done use an array to cycle thru the data.
Here is my data.
<tbody>
A
B
C
Customer
Invoice
Payment
2
John K Company
3060453
$1
3
John K Company
3060453
$7...
Hello all I have a Master Sheet that has Names in column A and each Name has its own Sheet and Data ex:
<tbody>
A1
BOB
A2
JOHN
A3
PETER
A4
SMITH
A5
LIZ
A6
TOM
</tbody>
I have A sheet named "1" in B1= BOB, Sheet named "2" B1= JOHN, Sheet named "3" B1= PETER
Sheet named "4" B1=...
I have a spreadsheet which, simplified, is in this format:
EUName >>>>>Product>>>>>>>>>>email
John Smith>>>>Computer>>>>john.smith@abc.com
Sara Jones>>>>Monitor>>>>> sara.jones@abc.com
<end spreadsheet="">
And I have some code (simplified version listed below), that when I put the cursor on a...
I think my formula may require MAX INDEX and MATCHsomehow, but I’m stumped.
I need to look at the earliest date and the latest date against memberslisted below (dates in between should be ignored). Ineed to then compare the Total Score against the earliest and latest date andif the Total...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.