wanted

Hi I’ve just registered on this site so apologises in advance if my post is incorrect in any way. I need some help : I have a list of postcodes for a particular county (wanted list) I have another list of random postcodes from lots of different counties (general list) I need to identify how...

Hi, Is there a way to define the Criteria1:=Array so that it shows all items except the ones you define? So how would i define the array if i wanted to show all values except Apple, Oranges, Pears? Thanks!

Hi, I have an data as mentioned below, If the wanted is zero, then the cell should be empty else it should show the number. <colgroup><col><col><col></colgroup><tbody> Stock Available Wanted 6 5 1 5 5 0 </tbody> can any one help me in this. Thanks in advance.

Hi and thanks in advance! until yesterday when I was debbuging my code in VBA. When Using F8 If I wanted to go one row Up or before, I mean if the yellow row was the 15th row and I wanted to move to the 10th row within the code, I used to use my mousse. and moving just with the mouse the...

I have a spreadsheet using several pivot tables, about 10 for every years analysis, over the last 7 years. Up to now, apart from learning how to achieve what I want, I have not had a problem I couldn't overcome. Each of the analysis years are in there own tab sheet and get data from one tab with...

HI, I have seen there are ways to return the smallest value with certain criteria using the SMALL(if(Criteria Array: Criteria Array=Criteria, Value Range:Value Range),1). I want to know if there is a way to identify the Smallest value and return a value in another column based on criteria...

Hi, I have a string of characters which starts from random numbers and ends with a letter. I want to add a "-" into every string right before the letter. For example: <tbody> String Wanted Result 51313202041A 51313202041-A 000035140B 000035140-B 9482939498c 9482939498-c </tbody> Any...

So I have recently decided I have really had enough of my mundane job and want to try to pursue something I enjoy. I have always wanted to program, I did attempt to try to teach myself a few years back & it went well, it's just hard to juggle a full time job and a family at the same time. But...

Hello All- The below formula gives me a check mark(W867), if cell G11 matches "O_P". I am having issues with the second part of the formula - I wanted a check mark also if G19 matches "PWS_LOG_WARE", if not "". =IF(ISNA(MATCH(G11,O_P,0)),"",IF(ISNA(MATCH(G19,PWS_LOG_WARE,0)),W867,"")) Please help

Hi, Is there a log file available in VBA? I could put the log in the worksheet but wanted to know if there were other options. Thanks

Hi, Is it possible to change the font in the vba module? I wanted to see apl thanks

Afternoon all, Is it possible to change the back ground colour on the multipages ? no default option appears ? also The caption you add to the pages, can that caption be formatted, as I wanted it to appear font size 12 and in bold ? Thanks Pauljj

<tbody> sortcut for booking acount team ch pt yth m total 001-cw we 09998475 44 66 110 003-dd rer 55656 38 20 43 101 </tbody> wanted code that check if total >0 then check the rows team,ch,pt,and yth m onlly if its > 0, otherwise move next line.

I have several workbook in my download folder, each workbook sheet1 has data (Sheet name is same for all), I wanted to move this sheet1 into another workbook with sheet name as 1, 2, 3...... Thank you for the help

Hi all, Just wanted to confirm is there any way we can create Add-in for Outlook( it includes Outlook Item_send). I wanted to trigger Event when ever user click to send mail, I know how the process works I can write manually (by pressing ALT+F11). But I have more than 100 user, I can't write...

Hello World! I've a question, I have a spreadsheet where I need to put some information in the cells, like "Type the code here" or "Insert comments here". I've messed with Comments and Entry messages, but none of them felt right for me.. :( I wanted to do like those "Old" programs, where...

Hi Frnd, I have built one checklist which works perfectly. It contains sheet event( Before double click and change). I have doubled checked there is no "workbook close" command in my code, but still getting close in middle. I just wanted to know what would be possible reason. any help would...

I am working on a 30-year plan. I want to have a row of years and the amount that would have to be put away each year. Lets say we had a $200,000 project that we wanted to do in year 2025 and we wanted to save for 3 years. 2019 would be 0, 2020 would be 0, 2021 would be 0 , 2022 would be one...

Hello, Been like 5 years since I used excel. I'm trying to free multiple rows for a table I'm creating. I have a table that has different categories and wanted to freeze the panes for each category. For some reason I can only freez one row in excel. Wanted to freeze like row 1 then row 30 the...

Hello Everyone, I have a challenge here with me: I have headers x y z. They keep repeating at regular intervals; x y z x y z etc. Now I want to count based on each header the number of cells that contain values greater than 0. I tried to use the countif but did not do what I wanted. I am...