The Data I have - extracted (about 80+ columns for different people and about 150 rows for the codes):
Contribution Site Codes
Person-A
Person-B
Person-C
Person-D
001-5500-000-55
50%
50%
003-6600-000-56
20%
40%
20%
10%
002-8800-000-57
20%
30%
001-0677-000-58
30%
40%
90%...
@ How to match Two condition & show value ???? via formula
1 st table to match 2nd table data , Need Both Condition Match (1) Invoice No. (2) CHA ,
And Get Result After match 1st table
Sorry guys, new to Excel and it was hard to make this formula. It is Literally the extent of my knowledge at this point to have even gotten it to work.
This formula takes a cell and looks for the persons name in a specific column on a sheet. If the name is found it returns the text in cell B1...
Can anyone please help me figure out a formula to calculate YTD??
What I am trying to achieve:
Sum all months <= current month, ONLY IF months fall within the same year CY (Calendar Year) as the current month
As you can see on the screenshot below, Cell B5 indicates the current month. The...
I created a new worksheet's and its 'worksheet_change' event procedure in 'worksheet_change' procedure of a existing worksheet, in its code I also pasted value in the new worksheet created newly, when I ran my code, the new worksheet and its event produce could be created properly, but the...
Dear All,
Pls help , i need to protect my connection or table properties to show any other users.
Pls suggest how to lock ribbon to show or how to lock DATA option in excel ribbon.
Thanks in adv.
Regards
Vishan
I wanna make return all item from a list that any cell contain specific key word. If possible in more advanced level, make the return from a range of cell instead of list of row. Thanks.
I created Checkbox Code that when checked, it brings me to the related worksheet and expands the rows. I want it to ONLY expand the row in the related worksheet and not actually bring me there. What do I have wrong? I am new to VBA so I can't seem to see the error...
Dear All Gurus,
I have a access having with table name "Daily_RTO" i want to send it on email "vishan.uk@gmail.com" by access VBA code using outlook email system.
Im new to VBA codes, pls suggest me full code of sending Access Tables and Select Queries to given email addess.
Thanks & Regards...
Hi Sir,
I have the some details like customer name.
Vishan Singh
Bob Simi
i want first name of customer in next column using text furmula.
Pls Help
Regards
Vishan:confused:
Dear All,
I want to update <0 data as 0 in many column at once mean in 1 query
Data is like
<table bgcolor="#ffffff" border="1" cellspacing="0"><caption></caption> <thead> <tr> <th bgcolor="#c0c0c0">DECR_01_Mar</th> <th bgcolor="#c0c0c0">DECR_02_Mar</th> <th...
I just got on data analysis using the “data sheet" function available under "what-if analysis". And it did not work<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<o:p> </o:p>
I followed all steps of the book (Excel bible 2007), for one cell change format...
I have read the thread on how to count only visible cells with other criteria, but I don't understand how to generalize this to my situation.
Here is the originial countif statement:
=COUNTIF(Data!T:T,"*"&B3&"*")
Here is the code that I have copied from previous threads, with my numbers...
Hello,
I'd like to be able to compare the data between two different worksheets to see the differences and then merge them together. Can anyone help? Thank you!
;)
Hello MrExcel, i want you to help me now.
How we get a coloumn that contain an updated list data entries directly from a running and real time recording?
example:
Day 1st
Time Name Buy
07.00 John 5 units
07.30 Smith 2 units
09.00 Alexa 3 units
10.15 John 2 units
Day 2nd
Time Name Buy
07.15...
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.