hospital

Hello, I did a list as suggested here : https://trumpexcel.com/excel-drop-down-list-with-search-suggestions/ It works very fine. However, I would like to improve it for my needs. My list in column F contains cell with many words, separated by a coma : “,” Example : F3 : house, cat, hospital...

Hello, I am trying to figure out a IF formula to say how may criteria mach with some codes. I have made a simple graph. Goal is to find a patient with two Codes specific codes, which is 96365 and J0984 <colgroup><col span="2"><col></colgroup><tbody> Location Patient ID Code Hospital 1 1...

Hi I have not done any coding in a very long time but I need to work out how to create a code for the following; I want to enter information on to the first worksheet, then the code to copy and paste the data to the selected hospital and ward entered in the cells on top of the worksheet. Each...

Hi all, I have a problem in issue the products on the basis of PO wise ( PO means purchased order issue by Hospital with all term and condition QTY, PRICE ,Supply, etc. ). We can’t serve complete PO qty on a one day with different reason but issue to hospital on demand basis. There is a problem...

https://docs.google.com/spreadsheets/d/1DQS_xqtr9X9tj6JXVKyofT99GWq7QMVGeqYj0PzF81w/edit?usp=sharing Attached is the sheet with an example. I have two facilities in my list: Washington Hospital MRI and Washington Hospital* but yet Index Match is reading them both as the same. Any idea as to why...

Hi, I have a workbook containing some data. Some of the columns contain more than 1 data put together in 1 cell. Now I have responsibility to separate them and make a new sheet with each item in its own column. The sheet contains 11 columns Columns 2, 4, 8 and 9 contain mixed entries Col2 =...

Hi, I've been lurking for a long time and have usually found a solution, but this is my first time posting. I'm basically trying to turn a data-table that lists where there are staffing gaps on a hospital's ward, in a list of where those gaps are. So the data table looks something like that...

I am creating a running inventory sheet. In most of the cells, there will be a serial number that I need to count as -1 from inventory count. In stock will be calculated separately, I need to continually subtract from In Stock to get my Available total. What formula should I use? In example...

I want to get a parent value into a new column based on a hierarchy in the same table, but the DAX documentation says LOOKUPVALUE doesn't work from the same table. I have a crude workaround but I'm thinking there must be something simpler. We have a single table of Global Location Numbers...

doctors list his specialization hospital name contact Address etc..

I have a workbook that has two sheets. Sheet 1 is all inventory. Sheet 2 is for the inventory in Sheet 1 that will be shipped to a specific location such as "Aspen Hospital". If "Aspen Hospital is typed into Sheet 1, I would like all information from that line copied into sheet 2. What...